phpBB v2.0.23 to vBulletin

[Bat21]

I'm looking to convert a phpBB v2.0.23 site that I have just acquired to vBulletin.

The problem is the phpBB site appears to be running some kind of portal. As I am not taking over the site for a few days I would like to get some feedback first as to what is the best way to go with the conversion.

Ideally I'd like to do this on a test database first but it appears that I can only download the latest version of phpBB v3.0.3, if I do a mySQL dump of the v2.0.23 data will it just import into the v3.0.3 if I set that up first?

Thanks.

[Steve Machol]

Yes, we have an import script for phpBB. You can read about it here:

http://www.vbulletin.com/docs/html/impex_phpbb2

Note: This will not import your portal or any data from add-ons.

[Bat21]

Steve, thanks for the reply. I realise that there is an importer for phpBB 2.

But is there any way I could set up a test environment that I can use without running the script on a live database?

I guess if take a complete backup of the whole site, then upload it to my server (different to the one it's on now) and then create another mySQL database on my server and then import the data into that one, I could then test it on that one?

Thanks.

[Jerry]

n a test database first but it appears that I can only download the latest version of phpBB v3.0.3, if I do a mySQL dump of the v2.0.23 data will it just import into the v3.0.3 if I set that up first?

Thanks.

ImpEx dosen't import from phpBB2 to phpBB3, and the phpBB3 scripts wont work with a v2 database.

Though to run an import, you don't need the scripts or the site running, just the source database so you can run your test import fine.

[Bat21]

ImpEx dosen't import from phpBB2 to phpBB3, and the phpBB3 scripts wont work with a v2 database.

Though to run an import, you don't need the scripts or the site running, just the source database so you can run your test import fine.

Nice one, so if I create an empty database and then populate it with the data from a 'dump' of the data from the phpBB2.. and then go ahead and run the ImpEx.

Many thanks guys.

[Jerry]

Nice one, so if I create an empty database and then populate it with the data from a 'dump' of the data from the phpBB2.. and then go ahead and run the ImpEx.

Many thanks guys.

Yup, that will do it.

For database systems ImpEx only ever reads from the database and never touches the files, so it won't even know they aren't there.

Having an inactive (i.e. not changing) source database is highly advised as well, so this situation is more ideal than not.

[Bat21]

I have finally got hold of the database now.

There is a big problem, it seems to have been modded in some way and all 125 of the table names are prefixed with nuke_ :mad:

I assume this is a mod that has been applied to the original phpBB v2 installation, the problem is now I don't know which tables are the ones I need to dump and which are part of the mod.

Does anyone have a list of what tables a standard v2 installation of phpBB2 should have and what are the table names :confused:

[Bat21]

C'mon guys, someone must know the answer to this one :(

[Steve Machol]

I have no idea what the default phpBB2 database has. You could just install one to compare.

[Bat21]

If I could find a copy of phpBB v2 somewhere then I could do what you suggest, but I can only seem to get hold of phpBB v3.

[Steve Machol]

Then my only other suggestion would be to post at the phpBB forums. Seems to be a more suitable place for a question regarding their db structure. :)