[REQUEST] Auto backup database

[H3llJ3oy]

Any ideal about that? A tool for auto backup databaseon time

[XxFearReaperXx]

.bat scripts ^^

@echo off
Set FDate=%Date:~-10,10%
Set Fdate=%FDate:/=-%
MD E:\backup\%FDate%\%FTime%
MD E:\backup\%FDate%\%FTime%\my
MD E:\backup\%FDate%\%FTime%\account
copy /y D:\wamp\mysql\DATA\my\* E:\backup\%FDate%\%FTime%\my
copy /y D:\wamp\mysql\DATA\account\* E:\backup\%FDate%\%FTime%\account

[H3llJ3oy]

Originally Posted by XxFearReaperXx

.bat scripts ^^

@echo off
Set FDate=%Date:~-10,10%
Set Fdate=%FDate:/=-%
MD E:\backup\%FDate%\%FTime%
MD E:\backup\%FDate%\%FTime%\my
MD E:\backup\%FDate%\%FTime%\account
copy /y D:\wamp\mysql\DATA\my\* E:\backup\%FDate%\%FTime%\my
copy /y D:\wamp\mysql\DATA\account\* E:\backup\%FDate%\%FTime%\account

Thanks, but first, we should stop mysql service

[XxFearReaperXx]

Well that's pretty obvious. ^^
sc stop mysql
sc start mysql

[idlemonkey]

just install navicat and look at the top where it says schedule ..... this is where you can set it to backup your database on a schedule using windows tasks, and run other scripts on a schedule as well