Scheduling MySQL database backups with date dependent filenames
Just wondering if it is possible to tell a MySQL server to backup files at a set interval but with a different filename each time which reflects the date. I know scheduled backups with the same name are possible (done through webmin, other ways too?), but this isn't what I'm looking for.
For example:
at 1am on January 22, 2006, the backup will be saved to a specified directory with the name 22-1-2006-DBNAME.sql
at 1am on January 23, 2006, the backup will be saved to a specified directory with the name 23-1-2006-DBNAME.sql
etc etc
Last edited by pepolez; 01-21-2006 at 08:26 AM.
|