Well, it's not a total loss you still have your inventories intact. Items are the real pain to restore, imho. What I'd do in your case is mark down the current IDs of all your toons and then wipe the character_ table. Then, re-create the toons in-game. Go back to the db, and change the toon's IDs so they match their old values. The next time you log in, all of your items will be there as you left them. From there, you just need to use GM commands to get your level, AAs, skills, and spell scrolls back. If you have a small private server, that won't be too bad. After you're done, immediately make a backup with mysqldump and check to make sure that the BLOBs are intact in it.
|