backing up multiple db's

[slighltywhacked]

I have a few domains with over 20 db's each, some of even go up to 50.

Decided it was time to start backing them up. I know it's possible to back them up, one at a time using mysqldump.. or even phpMyAdmin, but is there a faster way to back up all the databases?... Can I just download the db files somewhere??


thanx

[DR_LaRRY_PEpPeR]

if this is your server and you have access to all the databases, you can use the -A or --all-databases option to backup all DBs:

mysqldump --opt -A > /path/to/dump/file.sql

if you're on a shared server or something and don't have access to all DBs you'll get an error when mysqldump attempts to access the other DBs. the --force option may get around that problem, though, and just dump the DBs that you have access to. i'm not sure though.

mysqldump --opt --force -A > /path/to/dump/file.sql

or, finally, you can name all of the databases manually that you want to dump, which is faster than seperately. use the --databases option

mysqldump --opt --databases db1 db2 db3 db4 etc > /path/to/dump/file.sql

of course, in all examples, specify your login with -uusername -ppassword if necessary.