[REQUEST] Auto backup database

09/21/2013 20:01 H3llJ3oy#1

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

09/21/2013 22:57 XxFearReaperXx#2

.bat scripts ^^

Code:

@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

09/22/2013 05:05 H3llJ3oy#3

Quote:

Originally Posted by XxFearReaperXx

.bat scripts ^^

Code:

@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 :(

09/22/2013 06:29 XxFearReaperXx#4

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

09/24/2013 21:50 idlemonkey#5

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