Icy Phoenix

Hi,

I refer to this post: http://www.icyphoenix.com/viewtopic.php?f=2&t=2804&p=19690

For me its the same, I have a working phpbb2 witch is used by some users and I've got a working IP for testing.

Now I want to transfer all posts of the working phpbb2 to the new IP Portal.

I can't copy the hole database tables of the phpbb2 to the IP Installation because there're many changes on the database, see for example the forum table.

You can copy it.

There is no problem, as the non-value fields will take the default values.

novice programmer wrote: [View Post]

You can copy it.

There is no problem, as the non-value fields will take the default values.

So I only have to use the insert statements to update right? Because my actual backup contains "drop table if exists" statements, so the tables will be created new.

Novice can you explain it in more detail please? Many tables of IP have a other structure (more fields) than the tables in phpbb2. So a backup would set all tables to the phpbb2 structure.

Rene wrote: [View Post]

Novice can you explain it in more detail please? Many tables of IP have a other structure (more fields) than the tables in phpbb2. So a backup would set all tables to the phpbb2 structure.

Delete the instrucitons:



As in the other thread, make sure the prefixes are the same.

It doesn't work that easily I'm afraid. Just so no one get's the wrong idea this method doesn't work.

You will get this error:

#1136 - Column count doesn't match value count at row 1

I'll have to modify the script that mighty has in the contrib folder just to convert forums, users, and posts over.

If I have any luck I'll attach it here.