MySQL & phpBB Version Incompatibility

MySQL & phpBB Version Incompatibility

Posted by: monkfoto
Posted on: 2006-04-08 11:10:00

Hey All,

Since it's a DB for a phpBB I'm posting it here, though I suppose it may belong elsewhere.

The host I'm coming from used MySQL version 3.23.58. I need to import a DB from there to my Dreamhost account, but phpMyAdmin is giving me errors because apparently the syntax has changed since version 3.

How should I go about converting the old database from 3.23.58 to DH's 5.0.18? Any suggestions? Thanks,

monk

Re: MySQL & phpBB Version Incompatibility

Posted by: vicm3
Posted on: 2006-04-08 12:31:00

Well phpbb is now on his 2.0.20 release... and have no trouble with mysql 5... maybe, its worth to upload your db via ssh, do a import mysql db < yourdb, install latest php and go to update_to_latest, these update the tables to the latest mysql, add, remove, and generally go all good, anyway, backup your db first ;D

Regards

Re: MySQL & phpBB Version Incompatibility

Posted by: guice
Posted on: 2006-04-10 10:18:00

How did you export you DB? Using phpBB or mysqlexport?

What I'd suggest is to try different export options. There will be one that works. I'm actually a bit surprised that something is failing from 3.23 to 5.x. It's normally the other way around that dies.

Re: MySQL & phpBB Version Incompatibility

Posted by: norm1037
Posted on: 2006-04-10 11:47:00

I have just completed two transfers of phpbb from 2 old domains into DreamHost today and I used phpmyadmin both ends. I think they were mysql 4 though.

What error are you getting?

Have you had a look through the phpbb forum?


Tags: mysql