I've been asked to convert an old forum to phpBB3. The old forum is from a neglected Drupal forum-extension. The owner is not entirly sure wich version the old forum is, he thinks it's form Drupal 4. For easy reference in this post I'll call it "the Drupal forum".
Now, basically the Drupal forum is one of the simplest type of forum there is. There aren't categories, no seperate forums, basically no forum structure at all, just 1 big forum with all the topics in it. There's also no BBcode used.
I've read the sticky about importing the users, that shouldn't be much of a problem. But the second step is to import the topics and posts. How do I do that? All I have is a huge SQL file (~120 MB) of the entire Drupal site (forum + anything else one can put in Drupal). I've figured out what tables are related to topics and posts, so I guess I should copy those to a separate SQL file to make it more manageble. But then what? Since I don't have an XML file, I can't use the sticky for Generic Message Import. I guess the best approach is to loop over all the topics in the Drupal-DB and look for the related posts and then insert them step-by-step in de phpBB-DB.
Some questions though:
- Can I be sure that the import-users tool preserves the user-ids from the Drupal-forum? Otherwise, the poster-info for each post will be broken.
- Is there some generic function or SQL command for inserting topics and posts in the phpBB-DB?
- What's the chance of the server getting stuck on such a task? I think I should batch this process, any tips for that?
- Any other tips or thing I should consider before doing this?