定時備份mysql數據庫的批處理代碼，保存為backup_mysql.bat，運行即可。

復制代碼 代碼如下:

@echo off

set txt1=%date:~0,4%

::當前年

set txt2=%date:~5,2%

::當前月

set txt3=%date:~8,2%

::當前日

set txt4=%time:~0,2%

::當前小時

set txt5=%time:~3,2%

::當前分鐘

set txt6=%time:~6,2%

::當前秒

set date=%txt1%%txt2%%txt3%

set time=%txt4%%txt5%%txt6%

echo --------------------------------------------------

echo -------------正在執行MySQL數據庫備份--------------

echo --------------------------------------------------

echo ...

echo ...

echo 導出Database...

if exist %date%.sql del %date%.sql

c:\Progr*\mysql\bin\mysqldump --add-drop-table -c -u root -p-h localhost dbname >e:\%date%.sql

echo ...

echo ...

if exist dump%date%.7z del dump%date%.7z

echo 壓縮文件...

7za.exe a -t7z dump%date%.7z %date%.sql -mx9

echo ...

echo ...

echo 刪除臨時文件

del %date%.sql

echo ...

echo ...

echo 備份完成!

pause