在网上找的一段代码 这样只是备份了 还原的找不到 那个大侠 写下 本人菜鸟 对bat一点不会 下面是备份的代码
rem windows环境下Mysql数据库的自动备份脚本。
rem 可以将本批处理设成windows任务计划下自动执行
@echo off
@echo ================================================
@echo windows环境下Mysql数据库的自动备份脚本
@echo ================================================
rem 根据情况需要配置
rem 备份存放目录
set BACKUP_DIR="c:\"
rem mysql数据库目录
set MYSQL_HOME="C:\Program Files\MySQL\MySQL Server 5.0"
rem 用来备份的mysql帐号
set BACKUP_USER=root
rem 帐号密码
set BACKUP_PASSWORD=dcl_y152
rem 进行备份
rem 备份的数据库
set BACKUP_DB=bbs
for /f "tokens=1,2" %%a in ('date/t') do set TODAY=%%a
set BACK_NAME=%BACKUP_DB%_%date:~0,4%%date:~5,2%%date:~8,2%_%time:~3,2%%time:~6,2%%time:~9,2%
%MYSQL_HOME%\bin\mysqldump.exe -u%BACKUP_USER% -p%BACKUP_PASSWORD% %BACKUP_DB% > %BACKUP_DIR%\%BACKUP_DB%.sql
rem 将备份进行存档
cd %BACKUP_DIR%
copy %BACKUP_DB%.sql zip\%BACK_NAME%.sql
rem windows环境下Mysql数据库的自动备份脚本。
rem 可以将本批处理设成windows任务计划下自动执行
@echo off
@echo ================================================
@echo windows环境下Mysql数据库的自动备份脚本
@echo ================================================
rem 根据情况需要配置
rem 备份存放目录
set BACKUP_DIR="c:\"
rem mysql数据库目录
set MYSQL_HOME="C:\Program Files\MySQL\MySQL Server 5.0"
rem 用来备份的mysql帐号
set BACKUP_USER=root
rem 帐号密码
set BACKUP_PASSWORD=dcl_y152
rem 进行备份
rem 备份的数据库
set BACKUP_DB=bbs
for /f "tokens=1,2" %%a in ('date/t') do set TODAY=%%a
set BACK_NAME=%BACKUP_DB%_%date:~0,4%%date:~5,2%%date:~8,2%_%time:~3,2%%time:~6,2%%time:~9,2%
%MYSQL_HOME%\bin\mysqldump.exe -u%BACKUP_USER% -p%BACKUP_PASSWORD% %BACKUP_DB% > %BACKUP_DIR%\%BACKUP_DB%.sql
rem 将备份进行存档
cd %BACKUP_DIR%
copy %BACKUP_DB%.sql zip\%BACK_NAME%.sql