Page 1 of 1
mysqldump error
Posted: Wed Mar 11, 2009 10:44 pm
by m2babaey
Hi
I get this error when trying to backup my database ( the database contains 14000+ tables)
How can I solve it?
many thanks for your assistance:
the error is in the picture below:

Re: mysqldump error
Posted: Thu Mar 12, 2009 4:09 am
by VladSun
http://dev.mysql.com/doc/refman/5.1/en/ ... ndles.html
14'000+ tables
PS: There should be no white space between -p and you password (that's why you were asked for password).
Re: mysqldump error
Posted: Thu Mar 12, 2009 5:22 am
by Benjamin
You should really mask out your password. I read this post about 6 hours ago and still remember your IP.
Re: mysqldump error
Posted: Thu Mar 12, 2009 8:38 am
by m2babaey
Thanks for your attention
that's not my password (if you meant sp724co_sitesaz) but my database name.
do you see any other problem in my post?
thanks again
Re: mysqldump error
Posted: Thu Mar 12, 2009 9:01 am
by VladSun
Try using --skip-lock-tables mysqldump option, though there might be some minor problems (because tables are not locked).
Re: mysqldump error
Posted: Thu Mar 12, 2009 1:32 pm
by m2babaey
And how will the command chanage if i want to use --skip-lock-tables mysqldump option?
I'm beginner in ssh
also what can that minor problems be?
Thanks again for your help
Re: mysqldump error
Posted: Thu Mar 12, 2009 2:39 pm
by VladSun
Use it as any other option - just append it to to command line options:
Code: Select all
mysqldump -uUSER -pPASSWORD --skip-lock-tables db > db.sql
Re: mysqldump error
Posted: Fri Mar 13, 2009 1:09 am
by m2babaey
Thanks
One other thing
what is the job of -f in the command?

Re: mysqldump error
Posted: Fri Mar 13, 2009 3:50 am
by VladSun