https://www.icyphoenix.com/viewtopic.php?f=35&t=1430&p=10871#p10871
-----------------------------------
Vortex
Mon 26 Mar, 2007 21:18

Re: Any Way To Get Db From XS Into IP Without Overwriting XS
-----------------------------------
Sorry guys, I'm not expert but I have done something like that when I was on free hosting and needed more forums in one DB (yes, it is not quite the perfect way to work, but when you have not relevant interests and limited means...  :mrgreen:  )


If I understood you correctly, you want to continue working with XS while you ONLY TEST Icy upgrading it from your XS on the same db you have. [b]If I understood your situation[/b], I would do this way and I think it's quite easy:



[color=red][size=18]0. First of all BACKUP ALL your forum: files and db.
[/size][/color]


Then:

1. Backup your database (from phpmyadmin, both structure and datas in one .sql)

2. Upload a new XS (the same version you have) in another folder completely separated from your real forum and re-install it with a different table prefix (lets assume TEST_phpbbXS_ ).

3. After having installed the new XS, delete all TEST_phpbbXS_ tables you just created :mricy:

4. Take the backup at point 1 and with a text editor mass-replace all original prefixes with TEST_phpbbXS_

5. Via phpmyadmin, import the .sql file you just edited.



Now you got a perfect copy of your XS with different table prefixes. You can upgrade it to Icy and do all the tests you want.

If something goes wrong, be glad having observed point 0.  :mryellow: 


I described what [color=red]I[/color] would do in your situation, if something is missing or wrong please someone correct me.




Oh, anyway, the best solution is to test it local  :mrviolet:


