Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Is there a better (free) alternative to mysqldump? Because lately i'm having problems with corrupted database dumps. Mysqldump creates faulty sql code and when trying to restore the DB it fails with a lot of sql errors

So is there something better?

share|improve this question

closed as off-topic by Michael Hampton Aug 27 at 15:45

This question appears to be off-topic. The users who voted to close gave this specific reason:

If this question can be reworded to fit the rules in the help center, please edit the question.

2 Answers 2

mysqldump is the officially supported application for dumping MySQL databases. If you are getting faulty SQL code, then you should bring this to the attention of the developers by raising tickets.

I have used mysqldump over many years and never had any issues with it. Every single time it produced an output that differed from my expectations it was down to me having made a mistake. Maybe you should raise the specific problem you have on dba.stackexchange.com?

share|improve this answer
    
wolfgangsz, The webpage listed in your profile links to a drupal install. –  Iain Aug 28 '11 at 8:21

At first - i don't think some other app could be more safety then mysqldump. At second - i know next alternatives to mysqldump:

  1. mydumper
  2. Percona XtraBackup
  3. sypex dumper (work from command line too - recommended)
share|improve this answer

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