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


Published

Image

./scriptthe.net

Because 127.0.0.1 gets old after a while.

Back to Overview