Lastest Backup Procedures?

I ran a search on the forum and came up with several threads on backing up the accounts with different procedures.

Which are the most up-to-date backup procedures?

I am interested in this as well. I believed I was backing characters up using a method I read online, but when a server crash came along, I found out the hard way it didn't work.

I use Mangos BTW.

Im looking for the same thing im running mangos rev 2865 and i have the 3125 amber pack that i wanted to move my accounts into but the file structure for the charcters has changed and when i try to bring them over mangos database handler crashes any help would be apreachiated
thanks

I am looking for a good backup procedure as well. I exported the required tables suggested in the guides and imported them in the new database.

All is good when loading up the new server with new database, character shows up and all but when entering a world with a character the game freezes after the loading bar finishes loading.

I may be missing a table or maybe there is a script that can be executed in sql to do a proper backup. I'm gona try some tests and see if i can figure it out :)

heres a picture of what is happening
http://syntheticwow.no-ip.org/error.jpg
someone must have had this problem before please help me fix this issue i really dont want to start all new accounts
thanks

A couple of things:
1: For the screenshot supplied- What version of mdh are you using?
if you have got your accounts backed up, then you can make a clean
and try to import accounts again "just import sdb sql file, ignore the updates"
Also, what sdb/core are you using with this?

2: Backing up accounts can be done 2 ways-
Either export all the correct tables from mangos db, and back up the
whole realmd. Or, use mdh to back it up all for you. This is your best choise
as it's easier, I do both ways to be sure.


When using mdh to backup or import accounts, make sure you have newest mdh version, also not that the newest version of mdh is only for cores "3092" or above.

Go to Filebabe.com and download:

How and What to Backup for Updates

HINT: It is at the very bottom of the page.

Damn double post. Ragezone needs faster servers, it's been timing out way too much; removing the search function doesn't cut it.

it is the latest version of mdh 247 updated today i am trying to make a clean start its a brand new database on a diffrent pc i want to get it working there first so i dont have to shut the server down until i get the new one running.
the problem is when i inport the accounts the tables are moved all around so my old charcters stats are all messed up the collums in the database are not in the same spot any more http://syntheticwow.no-ip.org/db2.jpg
its just because the file structure has changed the old server is rev 2865 and the new is 3132 or 3125 i have both and have tried both.
thanks

Just so were all clear on which of the tables in the DB need to be backed up

Quote:

---

realmd
1 account
2 ip_banned
3 realmcharacters

mangos
1 auctionhouse
2 character
3 character_action
4 character_aura
5 character_homebind
6 character_inventory
7 character_kill
8 character_pet
9 character_queststatus
10 character_reputation
11 character_social
12 character_spell
13 character_stable
14 character_ticket
15 character_tutorial
16 corpse
17 mail
18 item_instance
19 guild
20 guild_member
21 guild_rank
22 guild_charter
23 guild_charter_sign

---

The most important thing to remember is the structure of the tables as THIS is what keeps changing!
So here's how to deal with making a backup that will import into a newer Db which is the crucial backup!

1. Import all sql's with number's greater than your current version from the latest revision's \sql\updates into your mangos Db
2. THEN backup with whatever you use

Personally I use db_backup.bat and db_update.bat to export and import players characters. It uses MySQLdump and is very fast :)