[Help] Database upgrade from Episode 3,5 to 4,3

[killuas]

Our server is successfully running Episode 3,5 for 2 years now.

We are making an upgrade to Ep 4,3, and here is the problem:

If I try to directly copy data from old base to new, all accounts, characters, items get new IDs in order of adding (while in the old base some IDs are missing because many IDs were deleted). thus all the base is messed up -- accounts and their items don't match.

That's why we need to know the proper query for moving database from Ep 3,5 base to 4,3.
Furthermore, the bases differ in some ways: 4,3's contains extra columns, it may cause some incompatibility.

Those of you who upgraded their servers from 3.x to 4.x could have solved this database problem.
Can you help us? It will save us days of work.

Thanks.

[MentaL]

[Aesir]

Once i had to upgrade GR dbs from 3.5 to 4.x, you need to create by yourself the proper queries for edit the existing tables in order to admit you to run the new version.

[killuas]

Once i had to upgrade GR dbs from 3.5 to 4.x, you need to create by yourself the proper queries for edit the existing tables in order to admit you to run the new version.

I need a sample query to copy account (character), and so on .. in another database table (a new version of the database).
I have created a new database. Now we have to move all how to do it?