Then put this batch file in your path too. Call it what you want.
Then you can setup the Schedule Tasks to run this batch file every day or whatever.
Begin cms_backup.bat
Code: Select all
@echo off
REM Create IBS MySQL Dump Backup
echo Creating MySQL Backup ...
c:\mysql\bin\mysqldump -uroot -pyourpass --all-databases > d:\Backups\IBS-MySQL.sql
set MONTH=
set DAY=
set YEAR=
set HOUR=
set MIN=
set SECOND=
set MONTH=%DATE:~4,2%
set DAY=%DATE:~7,2%
set YEAR=%DATE:~12,2%
set HOUR=%TIME:~0,2%
set MINUTE=%TIME:~3,2%
set SECOND=%TIME:~6,2%
set NEWFILE="IBS-MySQL-%YEAR%-%MONTH%-%DAY%-%HOUR%.sql"
REM Rename Backup to IBS-MySQL-YY-MM-DD-Hour.sql Format
echo Renaming Backup to %NEWFILE%
ren "d:\Backups\IBS-MySQL.sql" %NEWFILE%
REM Backup File To CD-RW at E:\
echo Erasing CDRW and Burning %NEWFILE% to CDRW
d:
cd d:\Backups
createcd -e -r:e %NEWFILE%
echo All Done.You can also probably use the same type of scenario on Linux with cdrecord.