Mysql – Incomplete MYSQL Dumps

mysqldump

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.

Best Answer

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