Thread:Project:Support desk/How to restore a wiki without a backup?/reply (10)

Let's see... Since you are on Windows 8.1 running on localhost, I think this should be doable with the Windows Task functionality:


 * I would set up a task. This task would run a .bat file. This file would then contain all the things needed:
 * I guess running this task would need the MySQL server to be started, so make it start the MySQL service.
 * It should then run a shell command, which creates a database dump. Ideally, the day of week somehow is in the filename of the dump, so that you get seven different files and then it starts to remove the oldest one. Maybe something like mysqldump.exe my-db -u root -psecretpassword > Database.%DATE:~7,2%.sql.
 * Stop the MySQL service again (ideally: only do so, if this script actually started the server; better do not stop it, if it already had been running before).

Note that I have not tried that myself, but here is a helpful post on the topic:

http://www.redolive.com/automated-mysql-backup-for-windows/