mysqldump error

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
m2babaey
Forum Contributor
Posts: 364
Joined: Sun May 20, 2007 9:26 am

mysqldump error

Post 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
User avatar
VladSun
DevNet Master
Posts: 4313
Joined: Wed Jun 27, 2007 9:44 am
Location: Sofia, Bulgaria

Re: mysqldump error

Post 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).
There are 10 types of people in this world, those who understand binary and those who don't
User avatar
Benjamin
Site Administrator
Posts: 6935
Joined: Sun May 19, 2002 10:24 pm

Re: mysqldump error

Post by Benjamin »

You should really mask out your password. I read this post about 6 hours ago and still remember your IP.
m2babaey
Forum Contributor
Posts: 364
Joined: Sun May 20, 2007 9:26 am

Re: mysqldump error

Post 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
User avatar
VladSun
DevNet Master
Posts: 4313
Joined: Wed Jun 27, 2007 9:44 am
Location: Sofia, Bulgaria

Re: mysqldump error

Post by VladSun »

Try using --skip-lock-tables mysqldump option, though there might be some minor problems (because tables are not locked).
There are 10 types of people in this world, those who understand binary and those who don't
m2babaey
Forum Contributor
Posts: 364
Joined: Sun May 20, 2007 9:26 am

Re: mysqldump error

Post 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
User avatar
VladSun
DevNet Master
Posts: 4313
Joined: Wed Jun 27, 2007 9:44 am
Location: Sofia, Bulgaria

Re: mysqldump error

Post 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
There are 10 types of people in this world, those who understand binary and those who don't
m2babaey
Forum Contributor
Posts: 364
Joined: Sun May 20, 2007 9:26 am

Re: mysqldump error

Post by m2babaey »

Thanks :wink:
One other thing
what is the job of -f in the command? :roll:
User avatar
VladSun
DevNet Master
Posts: 4313
Joined: Wed Jun 27, 2007 9:44 am
Location: Sofia, Bulgaria

Re: mysqldump error

Post by VladSun »

There are 10 types of people in this world, those who understand binary and those who don't
Post Reply