database import fail

Get help with installation and running phpBB 3.1.x here. Please do not post bug reports, feature requests, or extension related questions here.
Scam Warning
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

NOTE: phpBB 3.1.x is at its End of Life stage and support will NOT be provided after July 1st, 2018.
Locked
User avatar
robertmf
Registered User
Posts: 94
Joined: Wed Sep 25, 2002 7:26 pm
Location: 55 min. by commuter RR outside Filthadelphia
Contact:

database import fail

Post by robertmf »

3.0.12 -> 3.1.1 fresh install on LAMP

After looking at the 3.1.1 update I decided to do a fresh rebuild.

Trying to [IMPORT] the 3.0.12 mysql tables data into the virgin 3.1.1 database fails due to a duplicate PRIMARY KEY

Suggestions ? Hints ?

Thanks In Advance :)
Attachments
mysql import err.png
mysql import err.png (43.5 KiB) Viewed 173 times
DLI Alumni & Friends Community at DLIFLC.ORG

User avatar
Mick
Support Team Member
Support Team Member
Posts: 22268
Joined: Fri Aug 29, 2008 9:49 am
Location: Cardiff

Re: database import fail

Post by Mick »

Presumably the LAMP installation is a local test board? The best thing would be to start again by transferring your 3.0.12 board as per Knowledge Base - Transferring Your Board to a New Host or Domain to LAMP. Make sure everything is as it should be then carry out the upgrade following How do I convert my phpBB3 board to phpBB 3.1.x?.
"The more connected we get the more alone we become" - Kyle Broflovski

Please read: “Am I In The Right Place?” before posting.

User avatar
robertmf
Registered User
Posts: 94
Joined: Wed Sep 25, 2002 7:26 pm
Location: 55 min. by commuter RR outside Filthadelphia
Contact:

Re: database import fail

Post by robertmf »

Yes. local LAMP for testing. Thanks. I'll study the knowledge base link. Never occured to me to look since I've never run into this glitch.
DLI Alumni & Friends Community at DLIFLC.ORG

User avatar
robertmf
Registered User
Posts: 94
Joined: Wed Sep 25, 2002 7:26 pm
Location: 55 min. by commuter RR outside Filthadelphia
Contact:

[SOLVED] database import fail

Post by robertmf »

Mick wrote:Presumably the LAMP installation is a local test board? The best thing would be to start again by transferring your 3.0.12 board as per Knowledge Base - Transferring Your Board to a New Host or Domain to LAMP. Make sure everything is as it should be then carry out the upgrade following How do I convert my phpBB3 board to phpBB 3.1.x?.
The [DROP DATABASE] radio button export option was biting me in the arse :lol:
...umm... :twisted:
Attachments
1062 err.png
1062 err.png (21.59 KiB) Viewed 140 times
DLI Alumni & Friends Community at DLIFLC.ORG

Locked

Return to “[3.1.x] Support Forum”