1. Requirements
-WinRAR
-FTP client (command lines)
2. Create batch file (for example mysql_backup.bat) with following code
@echo off
setlocal
For /f "tokens=2-4 delims=/ " %%a in ('date /t') do (set mydate=%%c%%a%%b)
"<your mysql folder>\bin\mysqldump.exe" -u <mysqluser> --password=<mysqlpassword> yourdb > "<your mysql backup folder>\yourdb%mydate%.sql"
"<your WinRAR folder>\WinRAR.exe" a -r -inul<your mysql backup folder>\yourdb%mydate%.rar <your mysql backup folder>\yourdb%mydate%.sql
del <your mysql backup folder>\yourdb%mydate%.sql
copy <your mysql backup folder>\yourdb%mydate%.rar <your folder to upload>
ftp -v -i -s:ftpscript.txt
del <your folder to upload>\tmcrm%mydate%.rar
3. Create ftp script file (ftpscript.txt)
open <your server>
<username>
<password>
lcd <your folder to upload>
cd <your server folder to hold backup>
binary
mput "*.*"
disconnect
bye
4. Create Windows' task schedule for this mysql_backup.bat
End ./.
