Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.
Moderator: General Moderators
m2babaey
Forum Contributor
Posts: 364 Joined: Sun May 20, 2007 9:26 am
Post
by m2babaey » Wed Mar 11, 2009 10:44 pm
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:
VladSun
DevNet Master
Posts: 4313 Joined: Wed Jun 27, 2007 9:44 am
Location: Sofia, Bulgaria
Post
by VladSun » Thu Mar 12, 2009 4:09 am
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).
There are 10 types of people in this world, those who understand binary and those who don't
Benjamin
Site Administrator
Posts: 6935 Joined: Sun May 19, 2002 10:24 pm
Post
by Benjamin » Thu Mar 12, 2009 5:22 am
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
Post
by m2babaey » Thu Mar 12, 2009 8:38 am
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
VladSun
DevNet Master
Posts: 4313 Joined: Wed Jun 27, 2007 9:44 am
Location: Sofia, Bulgaria
Post
by VladSun » Thu Mar 12, 2009 9:01 am
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
Post
by m2babaey » Thu Mar 12, 2009 1:32 pm
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
VladSun
DevNet Master
Posts: 4313 Joined: Wed Jun 27, 2007 9:44 am
Location: Sofia, Bulgaria
Post
by VladSun » Thu Mar 12, 2009 2:39 pm
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
Post
by m2babaey » Fri Mar 13, 2009 1:09 am
Thanks
One other thing
what is the job of -f in the command?
VladSun
DevNet Master
Posts: 4313 Joined: Wed Jun 27, 2007 9:44 am
Location: Sofia, Bulgaria
Post
by VladSun » Fri Mar 13, 2009 3:50 am
There are 10 types of people in this world, those who understand binary and those who don't