[grosbouff]

Hi, I succeed to migrate from fluxbb to bbpress.

here are the queries I used. There are no explanations but maybe it will help you.

I made this by duplicating the tables fluxbb_forums,fluxbb_topics & fluxbb_posts in my bbPress database.

DON’T FORGET TO BACKUP BOTH TABLES BEFORE DOING ANYTHING !

For each table I deleted some fields and rename them to match bbpress structure, and at the end I import the datas in the right bbpress table.

http://pastie.org/571210

Do the queries one at time so you can check if there are errors.

I didn’t made anything on the users table as it’s integrated with WP on my website.

To give back a WP user its fluxBB posts; do this

UPDATE bb_posts SET poster_id=NEW_WP_USERID WHERE poster_id=OLD_FLUXBB_USERID;

UPDATE bb_topics SET topic_poster=NEW_WP_USERID WHERE topic_poster=OLD_FLUXBB_USERID;

When done, don’t forget to recount everything (posts, etc). in the admin panel.