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?
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?