Quick tip : How to back up all MySQL databases


Please shareShare on FacebookShare on Google+Tweet about this on TwitterShare on LinkedInShare on RedditDigg thisShare on StumbleUponShare 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}