Resource icon

bbPress Importer 1.0.0

No permission to download

shabbirbhimani

Active member
shabbirbhimani submitted a new resource:

bbPress Importer - Set of SQL Queries to import Data from bbPress over to xenForo

NOTE: This has been tested to work on a blank xenForo forum only.

I have attached the SQL script that imports the data from bbPress into Xenforo. I could not find any script to import bbPress 2.5+ data into xenForo and even tried bbPress to phpBB to xenForo but those 2 step process had their own issues.

So I created SQL script based on the bbPress to phpBB importer by iamsteadman on github. It imports...
Read more about this resource...
 

FancyFloyd

New member
How does this actually work? Where do I run it -- directly in the db as a sql command?

If that's how, I take it, it only works if both BBpress and XF are both on the same server?

Sorry for the noob questions.

EDIT: OK figured it out. Word to the wise, take note of Chris below.
 
Last edited:

Chris D

XenForo developer
Staff member
It has been identified that this importer does work, but it may leave some missing records which may affect certain features in XF, such as editing users.

It is recommended that after importing you should additionally run these queries to cover any possible missing records:
SQL:
INSERT IGNORE INTO xf_user_option (user_id) SELECT user_id FROM xf_user;
INSERT IGNORE INTO xf_user_privacy (user_id) SELECT user_id FROM xf_user;
INSERT IGNORE INTO xf_user_profile (user_id) SELECT user_id FROM xf_user;
INSERT IGNORE INTO xf_user_authenticate (user_id) SELECT user_id FROM xf_user;
 

mmirlach

Member
How does this actually work? Where do I run it -- directly in the db as a sql command?

If that's how, I take it, it only works if both BBpress and XF are both on the same server?

Sorry for the noob questions.

EDIT: OK figured it out. Word to the wise, take note of Chris below.
same noob question from my end: I do understand that I need to run the script in the db as a sql command but how do I connect from the xf database to the wp database?
or do I just need to add both databases to the same database user? (right now it's two databases on the same server but with different database users)
 
Top