Or you could set up a script that will create individual dumps for databases who's names are listed in a file. For example if your file that contains the list of databases you want to create mysql dumps for is called:
And you want the files to be created in /var/backups/databases. the script could look like:
for x IN `cat /home/me/mydb.list `
mysqldump -u <USER> -p<PASSWORD> $x > /var/backups/database/$x
1. The DO should be lower case do but it keeps showing as DO when I review my post.
2. You will need to use a real user name with access to the database in place of <USER> and <PASSWORD> and there is a space between -u and the user name but not between -p and the password.