Wipe? [Archive] - ForumsHQ

[iNViSiGOD]

I'll help ya out here Invisi



create a new bat file 'mysql-backup.bat' and add the following to it.



@echo off

echo Running dump...

c:\\bin\mysqldump -u[user] -p[password] --result-file="c:\\backup.%DATE:~0,3%.sql" [database]

echo Done!



obviously replace , [user], [password] and [database]



open cmd and paste the following



at 02:00 /every:M,T,W,Th,F,S,Su c:\\mysql-backup.bat





That should be it.



G'luck bud



Also:

if you would rather the backup be named by the actual date instead of the day of the week (like i have it above) change





%DATE:~0,3%



to



%DATE:~10,4%%DATE:~7,2%%DATE:~4,2%





NICE! I'll have to try that, I never thought to ask you if you wanted in on this project,seeing as how your superior when it comes to SQL compared to me.

[Ghaleon]

NICE! I'll have to try that, I never thought to ask you if you wanted in on this project,seeing as how your superior when it comes to SQL compared to me.



I actually have my hands full with the working im doing on the pervasive sql/majormud thing as well as my REAL work ATM :) But if you have any issues/questions just direct them my way.