vBJournal to WordPress MU Conversion

This is for advanced users only, and your mileage may vary.

With the demise of vBJournal recently, I wrote some pretty basic scripts to convert to WordPress MU. Since I just finished them about an hour ago, and I'm about to go on a month's holidays, there are bound to be some bugs. However, I have managed to convert around 100 journals from vBJournal to WordPress MU and so far it looks okay. I would advise that only those who are familiar with PHP and MySQL use these scripts.

I am attaching them to save other people time who may be thinking of doing something similar.

Note that users have to login to WPMU with a new account, details of which will be e-mailed to them using the e-mail address from their vBulletin account.

The procedure:

• Download and install WordPress MU STABLE from http://mu.wordpress.org/
• If you want to use the same database (not recommended) as vBulletin, you would skip the next two steps.
• Dump your user, journals, journal_entries, journal_comments tables from your vB database, e.g.:
  mysqldump -u vbusername -p vbulletin user > vbulletin_user.sql
  mysqldump -u vbusername -p vbulletin journals > vbulletin_journals.sql
  mysqldump -u vbusername -p vbulletin journal_entries > vbulletin_journal_entries.sql
  mysqldump -u vbusername -p vbulletin journal_comments > vbulletin_journal_comments.sql
• Import these tables into your WordPress MU database, e.g.
  mysql -u wpmuusername -p < vbulletin_journals.sql (and the same for user, journal_entries, journal_comments)
• Download the three script files here and copy to your wpmu/wp-inst directory.
• Edit the three script files, and change things like your_url (in wp-vbjusers.php), database, username, password, where_vbulletin_is, etc.
• From the command line (since it uses a HTTP POST to create each account, which can be slow if you have multiple accounts), in the wp-inst directory, do a php wp-vbjusers.php to create a blog for each user. Repeat this process for wp-vbjentries.php and wp-vbjcomments.php.

Good luck!

John.
--

[AN-net]

i believe the old will be reopened. i think im going to start on version two for vb 3.0.7

[Cloud-Warrior]

Cool - looking forward to it, I have vBJournal on another site that I don't want to change to WPMU just yet so will be implementing your fixed files when they are up.

[dsboyce8624]

Originally Posted by AN-net

i believe the old will be reopened. i think im going to start on version two for vb 3.0.7

I'll be very happy to have a fix.

[Ghostsuit]

Originally Posted by AN-net

not to intrude but i actually have one done but i want KirbyDE to check over it to make sure i caught everything

Excellent News.

[T3MEDIA]

Originally Posted by nexialys

if there is no link with vBulletin, it does not have to be released here...

this is not a forum for Wordpress development..,
(even if i work on the project myself!)

I see your back online... That is a good thing.

[Flexo]

With the vB 3.5-version of the journal coming out no earlier than 5 or 6 months from now, I´d say this import script has become interesting again...

Is there any progress?

[Cloud-Warrior]

I haven't tested it on the latest vBJournal, but I'd imagine it should still work.