I wanted to create a batch file that made a mysql backup with the dbname, date, time in the filename:
for /f "tokens=1,2" %%u in ('date /t') do set d=%%v
for /f "tokens=1" %%u in ('time /t') do set t=%%u
if "%t:~1,1%"==":" set t=0%t%
set timestr=%d:~6,4%%d:~0,2%%d:~3,2%_%t:~0,2%%t:~3,2%
"C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqldump" -u root --
password=YOURPASSWORD dbname > "C:\MySQLBackups\wikidbname\dbname-%timestr%.sql"
I then set it to look for and delete backups that where older than 14 days.
cd c:\MySQLBackups\wikidbname
forfiles /d -14 /c "CMD /c del @FILE"
Note: Make sure that there are NO FILES in the directory specified or they will be removed to include this batch file if you place it in that directory
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment