Comments on root.log: Backup all mysql databases to separate dump files

wow! thanks so much even though this is so old. I...

2009-02-25T19:22:00.000+01:00

wow! thanks so much even though this is so old. I have modified it even further so you can keep as many days as you want without over writing.

date=`date -I`
for i in /var/lib/mysql/*/; do
dbname=`basename $i`
mysqldump --password=yourpw $dbname > /root/mysqlbackups/$dbname-$date.sql
done

Indeed, rather old but very useful! Thanks for the...

2008-09-24T13:17:00.000+02:00

Indeed, rather old but very useful! Thanks for the concise piece of knowledge. :) Cass

Hey I know this is a crazy old post, but I found i...

2008-04-14T10:25:00.000+02:00

Hey I know this is a crazy old post, but I found it on google and it helped me a bunch, thanks!