Backing Up Multiple MYSQL Databases


Multi MYSQL Database Backup

With Cpanel and the mySQL console it is quite easy to backup a single mySQL database. But, if you have been in a situation where you are backing up a Cpanel account or have another scenario that includes multiple mySQL databases, you may find single mySQL database backups redundant.

Here is what you can do to back them all up in one shot.

Option# 1 Linux Command Line

 root# mysqldump -u root -p --all-databases > /home/username/alldbs.sql 

Option #2

Another option is to use a bash script and run it from the command line. Here is a link to a page that has this info.