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
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.