Propper backup procedure?

[Neoburn]

I of course did some searching for this and found very little and not enough to answer my question, but what is the best way to backup your server/database? I do a weekly clean up of the server and it would also be nice to toss in a backup in my list of tasks. Also, side thought, but is it possible to set a backup procedure as a automated process? As always, thanks for the help everyone.

[John Adams]

I'll reply before someone blasts a flame at you for posting a non-emulator related question here... ;)

If you d/l MySQL GUI Tools, the MySQL Administrator allows you to setup backups, even on a schedule. Check out the mysql website under downloads, I think.

[mattmeck]

I'll reply before someone blasts a flame at you for posting a non-emulator related question here... ;)


Assuming he is running the server under windows and wants to back up his EQEMu DB, it is eqemu related.

worst anyone can say is he should have posted in
Development::Tools
3rd Party Tools for EQEMu (DB management tools, front ends, etc...)

[Neoburn]

Assuming he is running the server under windows and wants to back up his EQEMu DB, it is eqemu related.

worst anyone can say is he should have posted in


hehe, it is a windows server if it matters lol

[John Adams]

Matt flamed me for preventing a flame!

:) I hope the tools tip helps.

[d00d]

I like Navicat, you can automate backups daily so you never have to worry about em.

[mattmeck]

Matt flamed me for preventing a flame!

:) I hope the tools tip helps.

If you would have prevented a flame there wouldn't have been one!!

So the case would be you caused one!!!1!

lol

[Neoburn]

Well, really apprecaite all of the suggestions guys :) Always appreciate the kind a curtious help everyone supplies on this forum. Much better than some other forums I have been on...then again, those had nothing to do with EQ hehe. I just need to figure out a 1130 error I keep receiving when trying to connect to mysql using the administrator part.

Thanks once again

[Kayot]

If you want to make a backup...

Question: Did you set the bin to the path during the MySQL Install? If not, your in for a world of hurt. If you did, do the following (I assume you know what DOS is)

Go into run and type cmd. Then after a black window appears type the following.

cd\
mysqldump -u root -p peq > peq.sql

The file will appear in what ever root directory you where in.

replace peq with what the database is named, and replace peq.sql with what every you want the backup named. I used to use MySQL Admin backup, but the files that Mysqldump makes, not only compress better, they start off smaller.

[John Adams]

If you would have prevented a flame there wouldn't have been one!!

So the case would be you caused one!!!1!

lol
Touche, my good man. ;)

[Neoburn]

I used the suggested Navicat MySQL program and set my scheduled backups which worked fine. Then I got the big idea of switching from the PEQ db to using both Angelox's and PEQ's by way of cavedudes installer. As directed by his readme, uninstall the old db so there isn't any conflict and reinstall, selecting both db this time. Well, as far as I know everything worked fine seeing as how I see my server in the server select screen (as far as it working outside of my network I have yet to check, but thats a different subject). Now, I tried importing specifically the account part of my old backups into both the new installation of the PEQ and AX db using Navicat. I see all of the accounts now in the tables, however, when I login to my server and get to the character select screen, I don't see any of the old toons. Where am I lost lol

Thanks for the help as usual everyone

[Angelox]

What I use most are the free tools MySql has posted; http://dev.mysql.com/downloads/gui-tools/5.0.html
MySQL Administrator will do the backups and much more
MySQL Query Browser is great for doing work on your database

Also GeorgeS has a free backup tool;
http://66.159.225.58/eqemu/eq.html

with MySQL Administrator you specify what you want to backup, select these tables;

account
character_
character_backup
faction_values
inventory
player_corpses
player_corpses_backup
sharedbank