https://www.icyphoenix.com/viewtopic.php?f=35&t=3434
-----------------------------------
iain
Fri 11 Jan, 2008 18:50

Moving From Phpbb 2.0.22
-----------------------------------
Hi.
I have a much modded board 
www.lowriderforums.com
and want to go to IcP.
IcP covers all of the mods [or variants] that I have anyway and I know I have some stuff from deleted mods.
Can i do a fresh IcP install and then use my existing phpbb DB?
or should I do  fresh phpbb install then upload the DB then change it to IcP?

amy help would be gratfuly recieved as i get lost easily [ didnt have computers when I went to school all those years ago  :) ]


-----------------------------------
Rene
Fri 11 Jan, 2008 19:02

Re: Moving From Phpbb 2.0.22
-----------------------------------
Hi,

for me it was nearly the same. I had a modded phpbb.

I made a fresh installation of IP in a new DB. Then I make a Backup (only Inserts) of the necessary tables from my phpbb.

Before I import the backup I delete all contens of the IP tables in which I want to import my backup.

At least I imported the backup. That was the best way for me. Probably there are other ways but this works for me at best.


-----------------------------------
xmenfile
Fri 11 Jan, 2008 19:42

Re: Moving From Phpbb 2.0.22
-----------------------------------
For me, you can just upgrade it from your moded Phpbb 2.0.22 and follow the upgrate IP instructions.  Rene is right, not that much different.  

enjoy, I love it.


-----------------------------------
TheSteffen
Sat 12 Jan, 2008 00:42

Re: Moving From Phpbb 2.0.22
-----------------------------------
Hi and welcome iain,

yes you can do an update from phpbb.

You should choose this last version of [url=http://www.icyphoenix.com/dload.php?action=file&file_id=54]Icy Phoenix

Then follow upgrade instruction

[size=12][color=#ff5500][b]Upgrade From Icy Phoenix 1.1.0.15[/b][/color][/size]
[spoiler][url=docs/readme_english.html#upgrade_ip]Readme[/spoiler]

Please follow the instruction step by step and don't care about point 10.  :mricy: 


[size=12][color=#ff5500][b]Fresh Installation[/b][/color][/size]
[spoiler][url=docs/readme_english.html#fresh_installation]Readme[/spoiler]

Use from the fresh installation point 3 and 4 to set permission.

If you have questions, feel free to ask.


-----------------------------------
iain
Sat 12 Jan, 2008 10:52

Re: Moving From Phpbb 2.0.22
-----------------------------------
thanks for the replies  :) 

since posting I had a play on a copy board using    ip_20080108_11015  [maybe the wrong one!]


when i used the update_to_ip file nothing seemed to happen............ does it happen quick without me seeing or should I get a screen saying something?


-----------------------------------
Rene
Sat 12 Jan, 2008 13:06

Re: Moving From Phpbb 2.0.22
-----------------------------------
[quote user="iain" post="23313"]
when i used the update_to_ip file nothing seemed to happen............ does it happen quick without me seeing or should I get a screen saying something?[/quote]

Hi, as I can remember step 6 of the installation is wrong. Don't lock your site and try again.


-----------------------------------
iain
Sat 12 Jan, 2008 17:18

Re: Moving From Phpbb 2.0.22
-----------------------------------
you are right  :)


-----------------------------------
Rene
Sun 13 Jan, 2008 11:41

Re: Moving From Phpbb 2.0.22
-----------------------------------
It would be nice if a mod updates the installation instructions. I point out this problem weeks ago at my own installation but there is no change of this error.


-----------------------------------
xMartinusx
Sun 13 Jan, 2008 21:41

Re: Moving From Phpbb 2.0.22
-----------------------------------
I'm going to move to a new hosting in the next month or so, can i just install a fresh IcP and move my DB to that hosting?
maybe a stupid question but i just know some basic stuff about this...


-----------------------------------
Rene
Mon 14 Jan, 2008 12:03

Re: Moving From Phpbb 2.0.22
-----------------------------------
[quote user="xMartinusx" post="23355"]I'm going to move to a new hosting in the next month or so, can i just install a fresh IcP and move my DB to that hosting?
maybe a stupid question but i just know some basic stuff about this...[/quote]

Yes you can, I think it is the same procedure as described in this thread.


-----------------------------------
Limun
Mon 11 Feb, 2008 14:34

Re: Moving From Phpbb 2.0.22
-----------------------------------
[quote user="xMartinusx" post="23355"]I'm going to move to a new hosting in the next month or so, can i just install a fresh IcP and move my DB to that hosting?
maybe a stupid question but i just know some basic stuff about this...[/quote]

i tryed this :
upload database of Phpbb 2.0.22 (made from acp with Phpbb 2.0.22) to new fresh instaled Icy (also in acp restore database) ant i didnt make it ...nothing happend...so i think its not posible ..but mabe i m wrong  :oops:


-----------------------------------
Rene
Mon 11 Feb, 2008 16:34

Re: Moving From Phpbb 2.0.22
-----------------------------------
Did you use the same prefix for the tables?


-----------------------------------
Limun
Mon 11 Feb, 2008 16:41

Re: Moving From Phpbb 2.0.22
-----------------------------------
[quote user="Rene" post="24102"]Did you use the same prefix for the tables?[/quote]

i must admit that i dont understand what u asking ..  :oops:


-----------------------------------
wizzard
Tue 12 Feb, 2008 07:17

Re: Moving From Phpbb 2.0.22
-----------------------------------
Thanks to all of you who have provided answers to this topic. Yet, it seems to me not clear enough how exactly one must proceed in order to complete a database import from Phpbb 2.0.22 into IP (the stable version) without lose of data.
I would very much appreciate a brief but clear tutorial on what exactly must be done (step-by-step).
I believe such a tutorial would clear many questions and would provide a more than welcome support to many of us.

Thanks in advance, folks.


-----------------------------------
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.


