Server_Backup

[cord]

I just got my server up and running but Im not sure how to back it up. It was hard to get it up and running took about 3 hours and been trying to years now that its working I want to make sure I can get it back. I may make a image of my whole computer for a main backup but what about my chars I cant make an image daily. What should I do?

[GeorgeS]

You are welcome to try my MySQL backup tool

http://66.159.225.58/eqemu/eq.html


GeorgeS

[Ueguvil]

Go Run -> Command

Go to C:\mysql\bin

Type: mysqldump databasename > something.sql

And if you just want to dump a certain table within your database (lets say the characters table), type:

mysqldump databasename characters > something.sql

[CrabClaw]

If you are using MySQL 5.0 or greater you can use the admin tool off the MySQL site to back up your database. It supports timed backups and such and its useful for managing stuff.

MySQL Admin Tool for 5.x (http://dev.mysql.com/downloads/administrator/1.1.html)

This is the tool I use personally. :) I also use the query browser utility there too they all work nicely.

MySQL Query Browser for 5.x (http://dev.mysql.com/downloads/query-browser/1.1.html)