[mwittrock]

Hi all

I’m in the process of migrating a custom-built PHP/MySQL forum (approx. 1.8 million topics and replies in total) to bbPress 2.5.8 on WP 4.5. My solution is to generate a bunch of bulk insert SQL scripts for wp_posts with post types forum, topic and reply.

This works. After the import, though, I need to run the bbPress repair tool, in order for posts, post counts etc. to be displayed correctly.

I’d prefer to avoid as many manual tasks as possible when switching from the old forum to the bbPress one, so I’m considering two options:

1) Run the repair from the command line rather than in the browser.

2) Generate the required wp_postmeta rows as part of my export.

I have a couple of questions about this:

Regarding option 1, is it even possible and does such a script exist?

Regarding option 2, what are the required wp_postmeta keys I would need to generate?

Thanks in advance for any input on this.

Kind regards,

Morten Wittrock

[Stephen Edgar]

Regarding option 1, is it even possible and does such a script exist?

Yes, there one, maybe two scripts, but they are quite out of date.

Regarding option 2, what are the required wp_postmeta keys I would need to generate?

Have you looked at the internals of any of the ~25 importers included with bbPress?

phpBB and SMF are the two most “feature complete” in that they import nearly 100% of the required wp_postmeta fields.

A basic example version of an importer is included, Example.php in the `/includes/admin/converters/ folder, its fairly basic, when comparing it with either the phpBB or SMF importers it might make more sense. There is also some initial documentation on modifying this yourself https://codex.bbpress.org/getting-started/importing-data/import-forums/custom-import/

If you upload to https://gist.github.com/ or somewhere, take a screenshot of it from phpMyAdmin I’ll happily help you get it up and running.

Also, I suggest using bbPress 2.6-alpha, loads of importer improvements over bbPress 2.5.9, you can grab it from here https://bbpress.org/download/