adding time stamp to mysql backup filenames

2 posts / 0 new
Topic locked
Last post
#1 Tue, 02/07/2012 - 12:03
nmournian@yahoo.com

adding time stamp to mysql backup filenames

Is it possible to add a timestamp in the file name that the mysql backup tool uses? I'd like to keep more than just the 'last' backup file in case I need to go back in time to recover older data... right now I have a nightly backup set (using the Bakup Database tool in the database manager section of virtualmin and it replaces the copy each time it backs up the database.

Tue, 02/07/2012 - 13:06
helpmin

You could use the "scheduled backups" tool in Virtualmin, select only mysql for the backup and then use the strftime format for the backup name (see also documentation).

Topic locked