So this is how I recommend everyone backup their database…It basically provides for any mucked database you might have by adding remove statements before the create statements. And it back’s up all the databases you have for a given MySQL instance…which makes life easier!

mysqldump -uroot -pawesomepassword --all-databases --add-drop-database --add-drop-table > db.sql

Blog Logo

Mario Loria




Because gets old after a while.

Back to Overview