MySQL5 Compatablity broke my char-select
 

I just got back from vacation and I wanted to update my server (Zebuxoruk), before I was at 7.800 and I went to 7.806. I'm using MySQL4 and plan on using that until the dev team switches to 5 (if they do). So I downloaded the new windows binaries as usual. Since i didn't know when if ever I would switch to mysql5 I went ahead and added those "compatability" lines of code in the log to SQL.

After I did all that I rebooted the server and all of my players were see'ing blank chracter select screens (the characters are still in the database just not showing up). I'm assuing it broke with the compatability.

Here are the lines I plugged in, anyone out there know enough SQL to reverse this?

ALTER TABLE spawn2 CHANGE `condition` `_condition` MEDIUMINT(8) UNSIGNED NOT
NULL DEFAULT '0';

alter table account DROP packencrypt;
alter table character_ change extprofile extprofile blob NULL;
alter table player_corpses change data data blob NULL;
alter table player_corpses_backup change data data blob NULL;

Thanks for any help, if any of my playerbase sees this hop to www.zebuxorukserver.com/forum (I'm working through this mess over there to keep you updated on when it will be back up)

Forgot to mention: My GM Account seems to work ok atleast my GM chracters always shows up and some of the other characters I've made for events show up (but not all of them) a lvl 85 my gm level 100 show up no other ones

I'm sorry to hear about your trouble. The easiest thing you can do is just to restore your previous days backup of your database. I haven't experienced the problem you describe. Maybe if some one else has had this problem they might have a better solution or atleast can provide additional data to recreate the problem.

I didn't backup before I made the changes, is there an auto-backup of the whole DB I can revert to?

(sorry I'm more of the in-game GM, didn't set up the DB but im trying to learn now that the GM that did for our server has become less active)

All you need to do is download MySql Administrator from the MySql site , you can make back ups with that - it's very easy. It will make auto-back up, but you have to set it up.

Awesome I'll set that up right now, still doesn't help me for now though. I'll keep playing with it, let me know if anyone needs some more information to hopefully get this resolved

I found something interesting. Certain characters are being removed from the characters database. If someone logs on to their account they get to the blank character select screen as I've said before. It seems like anyone that logged in while this was happening, their chracters have been cleared from the character list. They are still in the character_backup file so I'm hoping after I get this resolved I can backup the toons.

(Thanks for the Mysql Administrator advice, i set it up and have it on a scheduled backup, just need to get the server back up now)