XF 2.0 Importing from a large vBulletin database

djbaxter

Well-known member
I remember seeing something about this but can't find it.

I am considering migrating a vBulletin 4.2.5 forum with these stats:

Threads 60,236
Posts 9,021,738
Members 46,384

How easy is this to do and what issues should I anticipate?
 

Vekseid

Active member
Unless they've managed to bork things further from the 1.x importers (which are genuinely a mess), you should be able to setup a test install where you test the import function and see how it flows, what gotchas there are, anything that gets imported incorrectly, etc.
 

djbaxter

Well-known member
Yeah but that's not helpful. The owner is looking for some assurance BEFORE he buys Xenforo, instead of buying it and finding he's now got a big problem on his hands. I used the XF2 importer on a smaller vBulletin site and it worked flawlessly.
 
Last edited:

aagcrc

New member
Hi, I just imported and switch my Forum last night from vBulletin 5.4.3 (the most terrible mistake to upgrade to VB5) to XenForo 2.0.1 using the official XenForo Importers 1.0.2 and all was straight forward.

Threads 376,480
Messages 4,873,846
Members 38,182

Took a total of 8 hours

I just had to tweak couple things, changing the DB char_set to utf8mb4.general_ci and change the old_id column lenght to char(150) in the new import_log table.

My users love it, specially with the speed, since VB5 it was just WAY TO SLOW.
 

djbaxter

Well-known member
Thank you. (I agree about vB5).

The forum I'd be converting has over 9 million posts so I should anticipate a wait. Did you use the command line or the browser version of the importer?
 

Kirby

Well-known member
Total size is usually not an issue, though it does take quite some time to import a forum with several millions of posts, especially if there are many attachments/photos as well.

If possible, I'd always use CLI in a screen session - this has way less overhead then using the browser.

So far I've not migrated any big forums (e.g > 10M posts), but those we did so far (1M UBB.threads with a custom importer class and 600K phpBB 3 via XF 1.5) went without major issues.
 

Slavik

XenForo moderator
Staff member
Yeah but that's not helpful. The owner is looking for some assurance BEFORE he buys Xenforo, instead of buying it and finding he's now got a big problem on his hands. I used the XF2 importer on a smaller vBulletin site and it worked flawlessly.
Check my signature links, ive imported boards multiples larger than this fine, your biggest thing will likely be the wait time on the default importers.
 

djbaxter

Well-known member
Yes I'd definitely be using the command line version for this.

That's all promising - perhaps not the wait time but I can live with that. :)
 

aagcrc

New member
Thank you. (I agree about vB5).

The forum I'd be converting has over 9 million posts so I should anticipate a wait. Did you use the command line or the browser version of the importer?
I start the import in the browser with all the config, then move to CLI option.


Import complete!
Your import is now complete and the necessary caches have been rebuilt.

Import log table
xf_import_log
This table contains mappings from old IDs to new IDs. You may need this for redirection scripts.

Total run time: 6.48 hours

Import totals
User groups:24 (1 seconds)Custom user fields:1 (0 seconds)Users:75,067 (9.08 minutes)Avatars:5,198 (6.72 minutes)Buddy and ignore lists:1,067 (4 seconds)Paid subscriptions:0Custom BB codes:3 (0 seconds)Private messages:100,826 (11.40 minutes)Profile comments:1,294 (5 seconds)Forums:88 (2 seconds)Moderators:1 (0 seconds)Thread prefixes:0RSS feed sources:0Threads:377,050 (15.27 minutes)Tags:4,363 (27 seconds)Posts:4,878,718 (6 hours, 40 minutes)Edit history:5,327 (47 seconds)Polls:1,429 (52 seconds)Attachments:50 (23 seconds)Positive reputation:9,002 (2.63 minutes)Infractions:4 (0 seconds)CAPTCHA Questions:2 (0 seconds)Custom FAQ pages:33 (4 seconds)Announcements:4 (1 seconds)Notices:0Smilies: 226 (1 seconds)
 

aagcrc

New member
Yes I'd definitely be using the command line version for this.

That's all promising - perhaps not the wait time but I can live with that. :)
The stronger the server the faster. Also the config you could tweak php and mysql.
 

aagcrc

New member
When you install the importer add-on, you have to pre-configure the importer via Web Browser, then later go to the CLI and run the actual import based on the settings.
 
Top