批处理备份mysql数据库并压缩_mysql批处理 备份数据库-压缩文件

@echo off

rem

rem C:\Program Files\WinRAR 需要放到 path 下，才能调用rar cli工具

rem

rem 跳转到工作目录下

set dump_command="C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqldump"

set dbname=databasename

set backup_dir=F:\bak\

set timestamp=%date:~,4%%date:~5,2%%date:~8,2%_%time:~0,2%-%time:~3,2%-%time:~6,2%

set backup_fz_file="%backup_dir%\%dbname%_backup_%timestamp%.sql"

set BAK_FILE="%backup_dir%\%dbname%_backup_%timestamp%.rar"

set user_mysql=root

set password_mysql=root

echo backup mysql database:%dbname%

%dump_command% --opt %dbname% -h 127.0.0.1 -P 3306 -u%user_mysql% -p%password_mysql% --default-character-set=gbk >%backup_fz_file%

rem 压缩备份文件

rar a %BAK_FILE% %backup_fz_file%

rem 删除源文件

del /F %backup_fz_file%

echo end backup

下载次数: 8

0

顶

2

踩

分享到：

2011-08-11 17:47

浏览 1172

评论