[Help] Auto Backup Database

[matrix89]

Help!!
I need Auto Backup Software after 15 minutes or 30 minutes...Who have it...
i m try to use search button..but not found...
who have it..can release.

[XxFearReaperXx]

auto back up software? why not just use ur navicat premium and set a schedule to back it up?

[matrix89]

Originally Posted by XxFearReaperXx

auto back up software? why not just use ur navicat premium and set a schedule to back it up?

yup..for 5 minutes per day...who have it...

[DEADP00L]

Please Note that posting of Wares is aginst the Rules of the forum. Links and serials have been deleted

[King_Arthur]

Originally Posted by matrix89

Help!!
I need Auto Backup Software after 15 minutes or 30 minutes...Who have it...
i m try to use search button..but not found...
who have it..can release.

You can also write a batch script to copy your my folder elsewhere or zip/rar it to a specified location. Once it's working to your liking you can use the built-in windows task scheduler to run said batch file every x number of seconds/minutes/hours/days/weeks/years/decades ect.

[RADoss]

Originally Posted by King_Arthur

You can also write a batch script to copy your my folder elsewhere or zip/rar it to a specified location. Once it's working to your liking you can use the built-in windows task scheduler to run said batch file every x number of seconds/minutes/hours/days/weeks/years/decades ect.

that's about 9 times now you have made me feel like a complete noob for not thinking of it myself

[hio77]

Originally Posted by King_Arthur

You can also write a batch script to copy your my folder elsewhere or zip/rar it to a specified location. Once it's working to your liking you can use the built-in windows task scheduler to run said batch file every x number of seconds/minutes/hours/days/weeks/years/decades ect.

really the server should be closed while doing this or doing something like raring will miss certain files

[RADoss]

Originally Posted by hio77

really the server should be closed while doing this or doing something like raring will miss certain files

So I add task kill "MSG.exe" with small delay to the batch file right?
obviously not that exact code but just in lamens terms.

[King_Arthur]

Originally Posted by RADoss

So I add task kill "MSG.exe" with small delay to the batch file right?
obviously not that exact code but just in lamens terms.

If you kill the msg server everyone will be kicked out (and doing it that way might cause database corruption). What he was saying is that since the database is constantly changing it could produce problems in the backup, not catch anything, or perhaps cause server problems if the files are locked because said programs are accessing the same files.

Generally it is best (and probably easiest) to do your backups during server maintenance since you know the files are not being used by anything else. You could also research mysqldump and perhaps that can be run while the server is active.

[~WARNING~]

Originally Posted by King_Arthur

If you kill the msg server everyone will be kicked out (and doing it that way might cause database corruption). What he was saying is that since the database is constantly changing it could produce problems in the backup, not catch anything, or perhaps cause server problems if the files are locked because said programs are accessing the same files.

Generally it is best (and probably easiest) to do your backups during server maintenance since you know the files are not being used by anything else. You could also research mysqldump and perhaps that can be run while the server is active.

thats a myth lol

i don't wait for my msg server to close by itself, i end the process in the task manager and i haven't had any corruption yet, done it over 600 times now in the past 2 months

[DEADP00L]

Originally Posted by ibeatuall

thats a myth lol

i don't wait for my msg server to close by itself, i end the process in the task manager and i haven't had any corruption yet, done it over 600 times now in the past 2 months

and trust me it will happen. I have had it happen many times myself in the past. Dont assume because it aint happened to you that it wont.

[~WARNING~]

well in the off chance that does happen, i make a backup right before i close the msg server.

[matrix89]

Originally Posted by King_Arthur

If you kill the msg server everyone will be kicked out (and doing it that way might cause database corruption). What he was saying is that since the database is constantly changing it could produce problems in the backup, not catch anything, or perhaps cause server problems if the files are locked because said programs are accessing the same files.

Generally it is best (and probably easiest) to do your backups during server maintenance since you know the files are not being used by anything else. You could also research mysqldump and perhaps that can be run while the server is active.

how to set a time?
or..copy this script and make .bat file?

[RADoss]

Originally Posted by King_Arthur

Generally it is best (and probably easiest) to do your backups during server maintenance since you know the files are not being used by anything else.

Wait a second, I think that's matrixs' question in the first place.
How to say when the "Server Maintenance" will take place so we can safely backup/dump our DBs.

I have been dumping the DB using Navicats MySQL Dump method(on the fly) and it works very nice.
You can use the batch file method and set the time to start by adding that batch file in the Task Scheduler under System Tools.

Im also using Vista so the darn MSG server just crashes anyways lol

Matrix if you want to force your players to relog once a day in order to prevent botters, I suggest you manually restart by closing it out and letting it do its thing.
Might even try using an auto clicker like AutoIt to do the clicks for you ^^.
I'm not an expert on these server files but I know when TQ does maintenance they give warning u might lose info if u stay logged and then you suddenly d/c as if the MSG server were shut down. Just my two cents.