Bat指令碼實現MySQL資料庫SQL檔案備份

標籤：

@echo off
echo 線上兌獎系統自動備份指令碼（請勿關閉） 連絡人：  電話：
:loop
set /a "FDate=%date:~,4%%date:~5,2%%date:~8,2%"-5 
if %time:~0,8%==17:06:00 (
if exist "D:\mysql_db_backup\lottery_online_ticket_%FDate%.sql" ( Del /q /a "D:\mysql_db_backup\lottery_online_ticket_%FDate%.sql" )

C:\"Program Files (x86)"\"MySQL\MySQL Server 5.5"\bin\mysqldump.exe --opt -u root --password=admin lottery_online_ticket > D:\mysql_db_backup\lottery_online_ticket_%date:~,4%%date:~5,2%%date:~8,2%.sql
echo 備份完畢 ...

Echo open [ip]>ftp.up
Echo [username]>>ftp.up
Echo [password]>>ftp.up
Echo cd .\ >>ftp.up
Echo binary>>ftp.up
Echo put "D:\mysql_db_backup\lottery_online_ticket_%date:~,4%%date:~5,2%%date:~8,2%.sql">>ftp.up
Echo bye>>ftp.up
FTP -s:ftp.up
del ftp.up /q

echo =============備份等待=============
echo 線上兌獎系統自動備份指令碼（請勿關閉） 連絡人：  電話：
)
goto loop
@echo on

Bat指令碼實現MySQL資料庫SQL檔案備份