@echo off
echo Online Redemption system automatic backup script (do not close) Contact: Tel:
: 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 Backup Complete ...
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 ============= Backup Wait =============
echo Online Redemption system automatic backup script (do not close) Contact: Tel:
)
Goto Loop
@echo on
BAT script for MySQL database SQL file backup