I have another similar thread, but I added a lot of unneeded baggage to that thread.

Could I please get a command just to dump all my databases ( different domains) into their own sql backup files ?

I'd like to work with this cron syntax, since it already works fine for backing up individual sql files.

mysqldump -uadmin2 -p$(cat /etc/psa/psa.my/.psa.myshadow) MyActualDB > /var/www2/backup/mybackup1.sql

the above syntax is just for 1 sql file. But I need to add

all-databases

syntax in there somewhere.. Also, for each backup, to backup to their own SQL file . (preferably using their already established database name)

I really, really appreciate it.

if anybody cares.. latest details are here -

http://www.linuxquestions.org/questi...4/#post5347021

nice little script there as well..for people that need to dump all databases at once and have them renamed intot their own .gz file.