Quick tip : How to back up all MySQL databases

by

Please shareShare on Facebook0Share on Google+0Tweet about this on Twitter0Share on LinkedIn0Share on Reddit0Digg thisShare on StumbleUpon0Share on VKBuffer this page

To backup all or some of your MySQL databases, you’ll need mysqldump which comes bundled with mysql. If you have MySQL installed, you probably have mysqldump installed already.

To backup all databases use the following command:

mysqldump -uroot -ppassword --all-databases | gzip > /home/backupdir/db.sql.gz

{loadposition user9}