mysqldump mysql > D:\BackUp\DB_%date:~10,4%%date:~4,2%%date:~7,2%.sql注:D:\BackUp\ 是你希望备份到哪个文件夹.把上面的指令做成批处理文件,然后用计划任务,每天定时执行.
用计划任务 为什么MySQL要用MS SQL呢? 除非你的机器上也同时运行了MS SQL 2000
写的批处理文件 @ECHO OFFfor /f "Tokens=1 Delims=/ " %%i in ('date /t') do set dt=%%i for /f "Tokens=1" %%i in ('time /t') do set tm=%%i set tm=%dt%_%tm::=时%分SET bkupdir=E:\mysql\backups SET mysqldir=C:/Program Files/MySQL/MySQL Server 5.0SET dbname=ddd SET dbuser=ptsdb SET dbpassword=ptsdb SET CharacterSet=ujis@ECHO Beginning backup of %dbname%...mysqldump -B %dbname% -u%dbuser% -p%dbpassword% --default_character-set=%CharacterSet% --add-drop-database --complete-insert --opt>%bkupdir%\dbBkup_%dbname%_%tm%.sql @ECHO Done! New File: %bkupdir%\dbBkup_%dbname%_%tm%.sql rem dbBkup_ddd_2005-11-11_14时28分.sql pause然后在任务中定时执行即可 导出
为什么MySQL要用MS SQL呢?
除非你的机器上也同时运行了MS SQL 2000
@ECHO OFFfor /f "Tokens=1 Delims=/ " %%i in ('date /t') do set dt=%%i
for /f "Tokens=1" %%i in ('time /t') do set tm=%%i
set tm=%dt%_%tm::=时%分SET bkupdir=E:\mysql\backups
SET mysqldir=C:/Program Files/MySQL/MySQL Server 5.0SET dbname=ddd
SET dbuser=ptsdb
SET dbpassword=ptsdb
SET CharacterSet=ujis@ECHO Beginning backup of %dbname%...mysqldump -B %dbname% -u%dbuser% -p%dbpassword% --default_character-set=%CharacterSet% --add-drop-database --complete-insert --opt>%bkupdir%\dbBkup_%dbname%_%tm%.sql
@ECHO Done! New File: %bkupdir%\dbBkup_%dbname%_%tm%.sql
rem dbBkup_ddd_2005-11-11_14时28分.sql
pause然后在任务中定时执行即可
导出
mysqldump -h+(机器IP地址、本机用localhost) -u+(用户名) -p+(密码) + 数据库名 + ">"符号 + 保存路径和文件名。
例如我要把数据库名为 mydatabase 备份到 d:盘根目录下的 test.sql 文件中可执行以下命令:
>mysqldump -hlocalhost -uroot -proot mydatabase >d:\test.sql