Restoring An Old Backup

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Get Involved
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
Sjwdavies
Registered User
Posts: 10
Joined: Mon Aug 25, 2008 9:38 pm

Restoring An Old Backup

Post by Sjwdavies »

Hi guys, this is my first post so please take it easy one me :D

I'm trying to resurrect an old forum me and a few friends used to use.

I've registered the domain and transferred it to my own webserver.

I've installed the new shiny phpBB 3 however would like to restore all the old posts from the old forum, which was an earlier version of phpBB. I'm not sure which though.

The backup version I have of the database (supplied by the old webmaster) is dated 22nd November 2006.

As it was created using mysqldump, i'm unable to use the 'Restore' feature of the MySQL GUi.

My questions is this. When I try to:

mysql -u root -p forum_database < backup.sql

I receive an error saying "Error 1068 <42000> at line 972: Multiple Primary Key defined. Does anyone know if there's a way to override this?

I'm not sure what version of phpBB the previous site was using.

I'd appreciate any help or comments...

Pit$Bull
Former Team Member
Posts: 23099
Joined: Sat Dec 02, 2006 4:08 pm
Name: Can't Remember

Re: Restoring An Old Backup

Post by Pit$Bull »

Previous version by the date you mentioned is phpBB2 which is only compatible by conversion.
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.

Sjwdavies
Registered User
Posts: 10
Joined: Mon Aug 25, 2008 9:38 pm

Re: Restoring An Old Backup

Post by Sjwdavies »

this is my problem, I'm unable to install version 2.

When i try to recreate the version 2 database from my SQL backup file, I get the error message saying it's unable to create table xxx because it has multiple primary keys???

Also, I downloaded version 2 and tried to install it but it doesn't seem to have an install.php like version 3 - am I missing something obvious?

Many thanks

Pit$Bull
Former Team Member
Posts: 23099
Joined: Sat Dec 02, 2006 4:08 pm
Name: Can't Remember

Re: Restoring An Old Backup

Post by Pit$Bull »

You will need to post your topic in the phpBB2 forum for support getting version 2 installed http://www.phpbb.com/community/viewforum.php?f=1

Locked

Return to “[3.0.x] Support Forum”