新建mysql.bat,编辑以下内容:

@@echo off
set errorlevel=0
set path_home_mysql=C:\websoft\MySQL\MySQL Server 5.5\
set path_bin_mysql="C:\websoft\MySQL\MySQL Server 5.5\bin\"
set database_address=localhost
set database_mysql=database
set user_mysql=root
set password_mysql=root
set file_path=C:\bat\mysql\database_
set rand=%date:~0,4%%date:~5,2%%date:~8,2%%time:~0,2%%time:~3,2%%time:~6,2%
%path_bin_mysql%mysqldump.exe -h%database_address% -u%user_mysql% -p%password_mysql% %database_mysql% > %file_path%%rand%.sql
echo end backup

       如果需要定时导出数据库时,在windows下新建任务计划,触发器选择启动程序,然后选择该文件即可.

标签  技巧

按键盘左右方向键可快速浏览上一篇(←)、下一篇(→)