By JoeIsuzu on

I was trying to migrate an existing phpbb2/PostgreSQL install to a new Drupal/MySQL install on the same machine. I found that my version of MySQL was so old, it did not support "CREATE TEMPORARY TABLES" which appears to be required for phpbb2drupal.

So, I'm building out a new box using an up-to-date OS and MySQL, and I'm hoping to import the data directly from the PostgreSQL database on the existing box (on the same LAN). Can this be done, or do I need to dump the data, restore it to the PostgreSQL db on the new box, then import? I'm trying to minimize my downtime.

Perhaps more succinctly, can phpbb2drupal connect to PostgreSQL on the other machine (assuming it allows outside connections)?

When configuring phpbb2drupal, the "phpBB2 database location" defaults to "localhost" and it looks like I could replace "localhost" with the IP address of the other machine...right?

Thanks.
Jack

⋅ Categories: Drupal 4.7.x

Comments

JoeIsuzu’s picture

JoeIsuzu commented

Never mind, I installed PostgreSQL on the second box, and I took a data dump from the first one and restored it to the second. Now I have the phpBB2 data on the same box as the Drupal data.

Jack