Linux Perform MySQL Backup to time-based path from Webmin

Question

I was trying to setup a scheduled task in Linux Ubuntu Server 12.04 (CronJob) to perform a daily backup of all my MySQL Databases on midnight.

I have installed the known Webmin (A nice web interface for managing the Web Servers).

So my issue is: whenever the backup is being performed, the files are getting overwritten!

That means: The backup of the day before yesterday are LOST, only the "Yesterday" backup is being saved!

I have tried something like setting dynamic file path like:

/var/www/mysqlbackups/%d-%m-%y

but I had no success with that :(

Can anybody help me.

Thanks alot guys.

Answer 1

MySQL Database Server > Module Config > Chose Yes on "Do strftime substitution of backup destinations?"

It work for me! :)

Answer 2

You can use dynamic path, but before you must enable it in module config:

System > Filesystem Backup > Module Config > Do strftime substitution of backup destinations? > Yes

(If you are not sure about placeholders, just click on the text "Do strftime substitution of backup destinations?" in the config and help will show you.)

Answer 3

I had the same problem and solved like this :

From Server select MySQL Database Server. Go to Module config (top left), and select Do strftime substitution of backup destinations? to Yes.

I use db_%d-%m-%Y.sql format for backups. (db_13-03-2013.sql)