Menu
I have WampServer 2.0 that is installed on Windows on my laptop.
I'm running on it an application that I wrote. The application is working with MySQL database.
I would like to make backups of this database periodically.
How this can be done ?
How could I define cron on Windows ?
581
To back up a MySQL database, you can use either third-party tools or execute the mysqldump command from the command line. mysqldump is a command-line utility used to generate a MySQL logical database backup. It creates a single . sql file that contains a set of SQL statements.
In Database Explorer, right-click the database and select Backup and Restore > Backup Database. In the Database Backup Wizard, select the database, specify a path to the backup file, and enter the name of the output file.
The rough equivalent of crontab -e for Windows is the at command, as in:
at 22:00 /every:M,T,W,Th,F C:\path\to\mysql\bin\mysqldump.exe ...
Running the at command by itself lists the tasks you've created using at.
The mysqldump documentation is here.
135
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
