Quick tip : How to back up all MySQL databases

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}

  • http://ricardomartins.info/ Ricardo Martins

    very good to know. thank you