Quick tip : How to back up all MySQL databases

by
Share this Article: Facebook0Google+0Twitter0LinkedIn0Reddit0StumbleUpon0

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}

For questions please refer to our Q/A forum at : http://ask.unixmen.com/


Share this Article: Facebook0Google+0Twitter0LinkedIn0Reddit0StumbleUpon0