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:
Image

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 8O 8O 8O

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 :wink:
One other thing
what is the job of -f in the command? :roll:

Re: mysqldump error

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