I'm relatively new to the CMS world and am amazed that I haven't utilized CMS before! I've done lots of web design in the past, but it was almost always simple websites based in HTML or ASP.NET with very simple MS-Access databases. I also have a website that I installed a PHPBB forum on years ago. It's still in phpBB 2.0.21 .. I can access the admin menu from phpbb and I can also login to the phpmyadmin/index.php directory. I can figure out how to export the databases, but I can't figure out what to do from there.

I've installed drupal 6 on a new temporary domain setup by Godaddy. I was able to install the phpbb2drupal module, but I don't know where to go from there. I have an exported phpbb_db_backup.sql file from my other domain (exported from the phpbb2 admin menu) and I don't know what to do with it. Should I export from phpmyadmin instead?

Basically, I want to create a new website on a temporary domain that has the forum migrated into drupal... then I want to upload the new temporary website to replace the old one. Is this possible?

I'm embarrassed to say I don't even know what the difference between ProstgreSQL and MySQL is, nor do I know how to convert between the two.

I'm even confused by the file version of phpbb2drupal to use. I assume 6.x-1.2 is the one to use to migrate phpbb2 to drupal 6... because 5.x-3.0 converts phpbb3 to drupal 5, right?

Any help/step-by-step walkthrough would be greatly appreciated!

Thanks! :)

Comments

naheemsays’s picture

naheemsays commented

Since you have the sql file of the phpbb forum, most of the hard bit is done.

1. Get bigdump from here: http://www.ozerov.de/bigdump.php

2. extract it into its own folder and also place the sql file into it. edit the php file to point to the drupal database (you can copy the stuff from the drupal settings.php file which is probably located at sites/default).

3. Upload that folder to your hosting. You may want to zip/compress the sql file if it is large.

4. visit the bigdump.php file from a browser and run the script.

5. run the phpbb2drupal module - the phpbb data is in the same database in this instance.

as for what version.... 5.x-3.0 imports phpbb 2.x into drupal 5. (there is no supported path to import from phpbb3 to drupal 5). Drupal 6.x-1.2 also imports phpbb3 but into Drupal 6.

Current HEAD branch has almost final support to import from phpbb 3.x into Drupal 6.

goombamd’s picture

goombamd commented

Thanks for your help..

After some trial and error, here's the easiest way I came up with. Maybe it will help others who use godaddy and phpbb2.

1) Login to phpMyAdmin on the original site.
2) Open the database that contains the phpbb forum
3) Click on export.. and export the INDIVIDUAL tables. If you try to export the whole database, it won't work. There are only a few tables required. I had to export my phpbb_users table and a few others individually because apparently they can't be exported as a group. Not sure why? Security?
4) Once you have your exported tables as .sql files, login to phpMyAdmin on the temporary site via GoDaddy. (Login to godaddy.com, click on Hosting & Servers, Click on My Hosting Account, click on Manage Account next to the temporary site domain name, click on Databases, Click on MySQL, copy the database name (this is your username) and click on Open Manager. Login with your username you just copied and the password you setup for Drupal database password. )
5. Open the database name that is the same as your username.
6. Click Import at the top tab
7. import your .sql file/files

Now they should be accessible from the phpbb2drupal module :)

naheemsays’s picture

naheemsays commented

Have you also put in the correct database password, database name and location?

Also, if your php sql file is small (less than 2MB), you can import directly from phpmyadmin.

naheemsays’s picture

naheemsays commented
Status: Active » Closed (fixed)