Upgrading server from 4.3 to 5.0

[Arley McFarley]

Hello,

I want to upgrade my v4.3 server to v5.0 this weekend. It's a 4-day weekend for me.

I'd like to preserve the characters and inventory on the characters in the new 5.0 database. I plan to use the MWnpcdb_050_default0_3.zip to start.

I figure I need to export my characters data from the 4.3 eq database and source it into my new 5.0 eq database.

1. Anyone remember how to do this? Can you give me a couple of quick commands in MySQL for it (export and import)?

2. Any other tables or data I should transpose?

I think I did this once before, but my hardcopy notes and docs have gone the way of the 19-month-old. I'm not particularly fond of the way she manages my documentation, but Daddy's desk is a Wonderland for her and I can't really blame her when she smiles at me that way. You know?

Thanks, much!
Arley

[mattmeck]

actualy you Can NOT easily trancfer char from 4.whatever to 5.whatever.. There were too many changes made to everything. Items have new info imbedded into them, there item ID #;s have changed. Even the char info has changed.

I do know several people who have been trying to make a program to do what you want and they have had little to no success.


At this time even your old spawns / loot tables cant be used.

[Arley McFarley]

Okay, thanks.

Can I still use the Admin tool to add items, stats and coin to character inventory?

I'll check for a newer version of the Admin tool now.

If so, I can try to bring everything back to the way it was.

Thanks,
Arley

[mattmeck]

Nope there is not one DB editing tool for 5.0+ yet. There is talk of some being made but there still weeks to a month or more from completion from what i have read.

[Scorpious2k]

I do know several people who have been trying to make a program to do what you want and they have had little to no success.

Several? No success? I would be very interested in what they tried and what went wrong.

In the meantime, I have a little program I threw together I'd be willing to share. It's untested with the server, but produces expected results in the character and inventory tables.

[mattmeck]

Several? No success? I would be very interested in what they tried and what went wrong.


actualy i think they just tried to source in the whole DB, then tried each table sepretly. All to no avail. :x

[Arley McFarley]

Great.
I had planned to use the admin tool, but it sounds like it doesn't work. Sounds like I'll have to get in as GM and summon all the items to get us back to normal gear status.

Scorpious2K, if you want to share your inventory tool, I'll be happy to give it a shot and let you know how it worked.

I really just want to gear up our primary characters to equivalent gear status and stats. Anything else we can manage with summons, I think. It's just gearing 12 or so characters up that sounds tedious for the GMs.

Thanks for the responses, All.

Arley

[krich]

In the meantime, I have a little program I threw together I'd be willing to share. It's untested with the server, but produces expected results in the character and inventory tables.

I have the feeling that the guys at Winter's Roar might be VERY interested in seeing your program. Drop by #wr some time and see.

Regards,

krich

[Scorpious2k]

So far, we've successfully migrated/converted all NPCs/spawns/grids/factions/loottables so that the server now has the 150+ zones populated that we had in 4.4. This includes merchants, bankers and guild master NPCs. SQL updates easily changed them to the new class numbers. All NPCs have the loot they had in the earlier version.

We have doors done - they had to be changed by hand. All teleport doors should work (PoK, frozenshadow, etc).

We've also gotten the accounts table over, but not the character table, yet. Saving that for tomorrow :-) If the program I wrote works, we should have the characters converted then.

Unique items will have to be manually entered. Dindoleki aka Tark is doing that.

The only other big thing I see are the quests. We have a lot of them and have decided to switch to perl, so some major conversion will be involved. I still see us up this weekend if all goes smoothly.

[cybermax]

Scorpius : Do you have 150+ zones with spawns for 0.5.1 server up and running?

If so.. Is it any remote possibility to grab that DB, or is it kinda "copyrighted" by you now?

Just wondering, since the MWnpcmov db is the only "public" aviable db, and it has like 20 zones or so with spawns :(

[Scorpious2k]

Scorpius : Do you have 150+ zones with spawns for 0.5.1 server up and running?

Yes, we do. We have all but about 16-17 zones plus all of LDoN that are unpopulated. The rest are, including all of Luclin.

If so.. Is it any remote possibility to grab that DB, or is it kinda "copyrighted" by you now?

The problem with our DB is that it isn't quite eqlive standard. We have made a lot of modifications including unique MOBS and some zones that are higher levels, since our max level is 99 here.

Just wondering, since the MWnpcmov db is the only "public" aviable db, and it has like 20 zones or so with spawns :(

I've seen Tcs in action with previous DBs. He's great! I wouldn't be surprised if you see a lot of upgrades quickly.

Sorry I was so slow to reply. Its been a busy day. Between the holiday and the work we've been doing I haven't been camping on the forums like I usually do.

For the record... it was a productive day.

HEY MATTMECK!!! WE DID IT!!! . All characters have been converted from 4.4 to 5.1 :-) We are still tweeking some fields, but it is pretty much done. The program works.

[Arley McFarley]

Scorpikus,

Would it be possible to get some of the tables sourced out of your database? Seems like some of the tables for mob population, etc., might come in handy, even though you've got some serious customization going on.

Thanks,
Arley

[Scorpious2k]

My daughter (Myra on the boards) has talked about it. Maybe with a little encouragement....

(hint - PM her and cry a lot)