Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am using MySQL dump to back up my MySQL Databases and I'm having trouble with a couple dumps on one box.

Server Specs

Windows 2008

MySQL 5.1.48-community

I've tried various parameters in the mysqldump command and not much seems to help.

mysqldump --user=%mysqluser% --password=%mysqlpassword% --max_allowed_packet=64M \n 

What is odd, is if I do a dump out of phpmyadmin, it is fine.

share|improve this question
Are the missing objects the same between tries? – dezso Nov 12 '12 at 17:30
Is the dump file always 2Gb or 4Gb in size? – Phil Nov 12 '12 at 17:48
@dezo - it stops at the same point between tries – Bryan Smith Nov 12 '12 at 17:51
@Phil it is not anywhere near 2 or 4 gb – Bryan Smith Nov 12 '12 at 17:51
I've still had no luck with this any more ideas? – Bryan Smith Nov 13 '12 at 15:24

Use the -v (or --verbose) option for mysqdump which can show the errors that occur

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.