https://www.icyphoenix.com/viewtopic.php?f=35&t=3182
-----------------------------------
Rene
Wed 28 Nov, 2007 12:19

Phpbb2s Post To Running Ip
-----------------------------------
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.


-----------------------------------
novice programmer
Wed 28 Nov, 2007 18:33

Re: Phpbb2s Post To Running Ip
-----------------------------------
You can copy it.

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


-----------------------------------
Rene
Wed 28 Nov, 2007 19:47

Re: Phpbb2s Post To Running Ip
-----------------------------------
[quote user="novice programmer" post="21871"]You can copy it.

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

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.


-----------------------------------
Rene
Sun 02 Dec, 2007 14:16

Re: Phpbb2s Post To Running Ip
-----------------------------------
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.


-----------------------------------
novice programmer
Sun 02 Dec, 2007 20:52

Re: Phpbb2s Post To Running Ip
-----------------------------------
[quote user="Rene" post="21936"]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.[/quote]

Delete the instrucitons:

[code linenumbers=false]
DROP*
DELETE*
CREATE*
ADD*
ALTER*

to get only the insert lines[/code]

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


-----------------------------------
Stickygreen
Wed 02 Jan, 2008 19:06

Re: Phpbb2s Post To Running Ip
-----------------------------------
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.


