bat实现mysql备份

mysql_backup

 

@rem ---------------------------创建备份目录-----------------------------------------

@echo off   

set backup_dir=D:/数据备份

set backup_dir_run=D:/数据备份/run

set backup_dir_land=D:/数据备份/land

set log_file=%backup_dir%/backup_record.log 

if not exist "%backup_dir_run%" md "%backup_dir_run%"

if not exist "%backup_dir_land%" md "%backup_dir_land%"

@rem ---------------------------创建备份目录结束-------------------------------------

 

@rem ---------------------------取得当前时间----------------------------------------- 

set year=%date:~0,4% 

::当前年 

set month=%date:~5,2%

::当前月 

set day=%date:~8,2% 

::当前日 

set hour=%time:~0,2% 

::当前小时 

set minute=%time:~3,2% 

::当前分钟 

set mydate=%year%%month%%day%

set mytime=%hour%%minute%

@rem ---------------------------取得当前时间结束-------------------------------------

 

@rem ---------------------------设置标签-------------------------------------

set tag_long=echo --------------------------------------------------  >>%log_file%

set tag_short=echo ... >>%log_file%

@rem ---------------------------设置结束-------------------------------------

 

@rem ---------------------------备份数据库-------------------------------------------

%tag_long%

echo -------------正在执行MySQL数据库备份 [%date%%time%] --------------  >>%log_file%

%tag_long%

%tag_short% 

%tag_short%

set cmd_mysql=D:/WEBROOT/mysql50/bin/mysqldump -R -uroot -p111 

echo 导出d_land_run... >>%backup_dir%/backup_record.log

set sqlfile_d_land_run="%backup_dir_land_run%/d_run%mydate%%mytime%.sql"

if exist %sqlfile_d_land_run% del %sqlfile_d_land_run% 

%cmd_mysql% d_land_run> %sqlfile_d_land_run% 

echo 导出d_land_run结束... >>%log_file%

%tag_short% 

%tag_short%

 

echo 导出d_run... >>%backup_dir%/backup_record.log

set sqlfile_d_run="%backup_dir_run%/d_run%mydate%%mytime%.sql"

if exist %sqlfile_d_run% del %sqlfile_d_run% 

%cmd_mysql% d_run> %sqlfile_d_run% 

echo 导出d_run结束... >>%log_file%

%tag_short% 

%tag_short%

 

echo 导出d_run_shop ... >>%log_file%

set sqlfile_d_run_shop="%backup_dir_run%/d_run_shop%mydate%%mytime%.sql"

if exist %sqlfile_d_run_shop% del %sqlfile_d_run_shop% 

%cmd_mysql% d_run_shop> %sqlfile_d_run_shop% 

echo 导出d_run_shop结束... >>%log_file%

 

%tag_short% 

%tag_short%

 

echo 导出bugs... >>%log_file%

set sqlfile_bugs="%backup_dir_land%/bugs%mydate%%mytime%.sql"

if exist %sqlfile_bugs% del %sqlfile_bugs% 

%cmd_mysql% bugs> %sqlfile_bugs% 

echo 导出bugs结束... >>%log_file%

 

%tag_short% 

%tag_short%

 

echo 导出discuz... >>%log_file%

set sqlfile_discuz="%backup_dir_land%/discuz%mydate%%mytime%.sql"

if exist %sqlfile_discuz% del %sqlfile_discuz% 

%cmd_mysql% discuz> %sqlfile_discuz% 

echo 导出discuz结束... >>%log_file%

%tag_short% 

%tag_short%

echo 导出land... >>%log_file%

set sqlfile_land="%backup_dir_land%/land%mydate%%mytime%.sql"

if exist %sqlfile_land% del %sqlfile_land% 

%cmd_mysql% land> %sqlfile_land% 

echo 导出land结束... >>%log_file%

%tag_short% 

%tag_short%

echo 导出landwiki... >>%log_file%

set sqlfile_landwiki="%backup_dir_land%/landwiki%mydate%%mytime%.sql"

if exist %sqlfile_landwiki% del %sqlfile_landwiki% 

%cmd_mysql% landwiki> %sqlfile_landwiki% 

echo 导出landwiki结束... >>%log_file%

%tag_short% 

%tag_short%

echo 导出mysql... >>%log_file%

set sqlfile_mysql="%backup_dir_land%/mysql%mydate%%mytime%.sql"

if exist %sqlfile_mysql% del %sqlfile_mysql% 

%cmd_mysql% mysql> %sqlfile_mysql% 

echo 导出mysql结束... >>%log_file%

%tag_short% 

%tag_short%

echo 导出wikidb... >>%log_file%

set sqlfile_wikidb="%backup_dir_land%/wikidb%mydate%%mytime%.sql"

if exist %sqlfile_wikidb% del %sqlfile_wikidb% 

%cmd_mysql% wikidb> %sqlfile_wikidb% 

echo 导出wikidb结束... >>%log_file%

%tag_short% 

%tag_short%

echo -------------备份完成! [%date%%time%] --------------  >>%log_file%

@rem ---------------------------备份数据库结束---------------------------------------