dumping mysql db script with dates
Morning,
Doing mysql db dump on a cron job from a file that has something like:
mysqldump --databases db1 db2 db3 > /var/www/Backup/dbs.txt --opt -p
Which is run once a week.
What i'd like is rather than it overwrite the file everyweek, to do it by date so I get a list of:
31_3_04_dbs.txt
24_3_04_dbs.txt
etc
any ideas?
|