mysql在WIN下的备份BAT

最新推荐文章于 2024-12-26 16:40:27 发布

原创最新推荐文章于 2024-12-26 16:40:27 发布 · 134 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#MySQL #BBS #SQL #SQL Server #C

本文介绍了一个用于备份MySQL数据库的批处理脚本。该脚本能够自动备份三个不同的数据库（bbscs8、jtrac 和 wiki），并采用当前日期和时间作为文件名的一部分以区分每次备份。备份文件将被保存在U盘根目录下的特定路径中。

@echo off
set errorlevel=0
set dump_command="C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqldump"

set db_bbs=bbscs8
set db_bug=jtrac
set db_wiki=wiki

set backup_dir=U:\bak\mysql\
set timestamp=%date:~,4%%date:~5,2%%date:~8,2%_%time:~0,2%-%time:~3,2%-%time:~6,2%

set backup_bbs_file=%backup_dir%%db_bbs%_backup_%timestamp%.sql
set backup_bug_file=%backup_dir%%db_bug%_backup_%timestamp%.sql
set backup_wiki_file=%backup_dir%%db_wiki%_backup_%timestamp%.sql

set user_mysql=root
set password_mysql=virtual

echo backup mysql database:%db_bbs%
%dump_command% -u%user_mysql% -p%password_mysql% %db_bbs% > %backup_bbs_file%

echo backup mysql database:%db_bug%
%dump_command% -u%user_mysql% -p%password_mysql% %db_bug% > %backup_bug_file%

echo backup mysql database:%db_wiki%
%dump_command% -u%user_mysql% -p%password_mysql% %db_wiki% > %backup_wiki_file%

echo end backup