Can This Database Move Even Be Done

[MSRmafia]

Ashamed to say after several years of procrastination that I'm finally moving my board to a new server and looking to upgrade it.

It's a dinosaur at version 2.0.21.

Is there any hope of moving the username, post and private message database to a 3.3.0 installation?

If so, any guidance for a newbie is greatly appreciated.

[Mick]

Information on how to convert from phpBB2 to phpBB3 is here.

Basically, you must have both phpBB2 and phpBB3 installed on the same server. After you have finished installing phpBB3 you will have the option to convert your phpBB2 board using the built in converter. The information it asks you for is related to the phpBB2 installation and can be found in its config.php file on the server. All of your users, posts, forums, PMs etc are converted. However, styles and MODs are not (with the exception of the birthday and attachment MODs which are supported by the converter). The phpBB2 database is not converted per se, it is merely read and converted/moved to the new phpBB3 database, so if it goes wrong your old board will not be affected at all. At the end of the conversion, once you're happy it's all working, your phpBB2 database and files can be backed up and removed if you so wish. They are not connected to the new installation in any way.

(3.2 is mentioned In the instructions but you can use the latest 3.3)

[MSRmafia]

After exporting the old database from the old server, I received the following errors while importing the old database into a blank database on the new server.

- #1062 - Duplicate entry 'cliche' for key 'PRIMARY'
- INSERT INTO phpbb_search_wordlist (word_text, word_id, word_common) VALUES('cliche', '240050', '0')

Any insight on what I need to do here?

Thanks again for any-and-all help.

- Ben

[stevemaury]

TRUNCATE the three search* tables from the version 2 database and then export it and try importing it again. Those table can be rebuilt after you get everything updated.