How do I load 5.0 characters into 5.1 DB? Items all gone!
 

I am trying to upgrade from 5.0 to 5.1, but for some reason all the equipments and items on those old characters are gone!
I can summon items, so the items are fine. Did anyone encounter similar problems? Anyone knows how to load characters from 5.0 db to 5.1 db?

What I did was, started in mysql, run these to make the character_ table compatible with 5.1 format before backup:
mysql>alter table character_ add timelaston int(11) unsigned default '0';
mysql>alter table character_ add publicnote varchar(100) NOT NULL default '';

Then under dos prompt, backup the account and character table:
c:\mysql\bin\mysqldump -u root eq account > account.sql;
c:\mysql\bin\mysqldump -u root eq character_ > character.sql;

Then log into mysql, run the following to update to 5.1 DB:
mysql>drop database eq;
mysql>create database eq;
mysql>use eq;
mysql>source MW_051_052_alpha1.sql;
(here i used tcsmyworld's latest db)

Then source in the accounts and characters:
mysql>source account.sql;
mysql>source character.sql;


Did I missed something?

The following are the table you need to backup if you want to keep your chars

account
character_
inventory
player_corpses
sharedbank
faction_values

items are stored in the inventory table, they arent stored in the character profile anymore

Thanks so much for the quick reply, and luckily I did a whole backup of my old database before upgrade.