如何在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
.