[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 View Post
.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