https://www.icyphoenix.com/viewtopic.php?f=35&t=3434&p=24136#p24136
-----------------------------------
Rene
Tue 12 Feb, 2008 12:42

Re: Moving From Phpbb 2.0.22
-----------------------------------
At first try it like the way its described here:

http://www.icyphoenix.com/viewtopic.php?f=1&t=1997  

Upgrade From phpBB 

You don't have to lock you site (step 6). This produces errors for many people.

When this doesn't work you can try that my solution:

---------------------------------------------------------------------------------------------------

[b]I[/b] did it in that way:

1. Fresh installation of Ip in a new database. Its also possible to use the same database with another table prefix
2. Backup of the following phpbb2 tables:

[code linenumbers=false] phpbb_auth_access 
 phpbb_banlist 
 phpbb_categories 
 phpbb_forums 
 phpbb_groups 
 phpbb_posts 
 phpbb_posts_text 
 phpbb_privmsgs 
 phpbb_privmsgs_archive 
 phpbb_privmsgs_text 
 phpbb_ranks 
 phpbb_search_results 
 phpbb_search_wordlist 
 phpbb_search_wordmatch 
 phpbb_sessions 
 phpbb_sessions_keys 
 phpbb_topics 
 phpbb_topics_watch 
 phpbb_users 
 phpbb_user_group 
 phpbb_vote_desc 
 phpbb_vote_results 
 phpbb_vote_voters 
 phpbb_words [/code]

3.I edited the backup file, that I only had the insert statements (I opened the sql file with an editor an deleted everythink except the insert statements)

The result was like this: 
[code linenumbers=false]
INSERT INTO `ip_search_results` (`search_id`, `session_id`, `search_array`, `search_time`) VALUES
...

[/code]

4. Change the prefix of all backup tables to the prefix you use for IcyPhoenix. In this example you would change phpbb_ to ip_ (you can use the search and replace function)

5. Clear all IcyPhoenix tables in witch you want to insert (the same table names as mentioned in 2 with other prefix)

[code linenumbers=false]

SQL Query:

TRUNCATE TABLE `<table name>`;
...
[/code]

6. Insert your backup file in the database of IcyPhoenix.


