0

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 
    INSERTDBNAMEHERE INSERTTABLENAMEHERE > %basedir%\export.sql 

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

  • 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
1

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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