admin:date_in_filename
@ECHO OFF for /f “tokens=1-4 delims=/ ” a in ('date/t') do ( set dw=a set mm=b set dd=c set yy=d ) SET bkupdir=C:\path\to\where\you\want\backups SET mysqldir=D:\path\to\mysql SET dbname=this_is_the_name_of_my_database SET dbuser=this_is_my_user_name @ECHO Beginning backup of %dbname%... %mysqldir%\bin\mysqldump -B %dbname% -u %dbuser% > %bkupdir%\dbBkup_%dbname%_%yymmdd%.sql @ECHO Done! New File: dbBkup_%dbname%_%yymm%%dd%.sql pause
admin/date_in_filename.txt · Last modified: 2009/05/11 15:30 by 127.0.0.1