Take the 2-minute tour ×
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. It's 100% free, no registration required.

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.

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? –  FreshPhilOfSO 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
show 1 more comment

1 Answer

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

share|improve this answer
add comment

Your Answer

 
discard

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.