如何在Windows上备份MySQL数据库?

问题描述:

我在笔记本电脑上的Windows上安装了WampServer 2.0.

I have WampServer 2.0 that is installed on Windows on my laptop.

我正在其上运行我编写的应用程序.该应用程序正在使用MySQL数据库.

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.

这怎么办?

如何在Windows上定义cron?

How could I define cron on Windows ?

对于Windows,crontab -e的大致等效是at命令,如下所示:

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 ...

单独运行at命令会列出您使用at创建的任务.

Running the at command by itself lists the tasks you've created using at.

mysqldump文档在这里.