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:
---------------------------------------------------------------------------------------------------
I 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:
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
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:
INSERT INTO `ip_search_results` (`search_id`, `session_id`, `search_array`, `search_time`) VALUES
...
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)
SQL Query:
TRUNCATE TABLE `<table name>`;
...
6. Insert your backup file in the database of IcyPhoenix.
]
