Convert vB to SMF Through Backup

[ProtomanP1]

I used to have a vBulletin 3.8.3 forum, but it crashed.

I still have a backup from before the crash as in a sql file.

Can I use the backup file to get my old forums on SMF?


How?

[Norv]

You can restore the backup into a database, because the converter needs to connect to that database and work with it.

Please note that it may be easier if you restore it into a database with the same name and server as the former vBulletin's database, because the converter will use a vBulletin config file to identify it.

[ProtomanP1]

Okay I rebuilt the database thru the back up.

Now how do I point the converter to the new database? where is it located?

[Norv]

Please check out:
Converting to SMF

Specifically for vBulletin, the converter looks for the files:
your_vBulletin_folder/admin/config.php
your_vBulletin_folder/includes/config.php
(any of them would suffice). It will read the database data from there.

Please note also that in case you want to convert to SMF 1.1.10, the converter files as listed for download here will be fine: http://www.simplemachines.org/community/index.php?topic=262571.0
In case you wish to convert to SMF 2.0, you may find useful to use the files attached here.

[ProtomanP1]

okay m8 thanks alot!

Only I got another problem now

when converting i get this error

Unknown column 'memberName' in 'field list'

[Norv]

It sounds like you are trying to convert to SMF 2.0 ?

If that is the case please note:

In case you wish to convert to SMF 2.0, you may find useful to use the files attached here.

See my post above for the converter files for SMF 2.0.

[ProtomanP1]

I must have clicked the wrong link, i could swear I did it right lol.

Again I get an error though

Recalculating forum statistics... Table 'aiclan_SMF.smf_{db_prefix}topics' doesn't exist

[Norv]

Oops. Please try using this file instead.

[ProtomanP1]

How can I ever thank you?

Best service I ever had

[Norv]

Good to hear it works!

Marking this as solved, but please feel free to ask for more assistance in case you may need.

[leonpadi]

Yeap i confirm one more succeeded conversion from 3.8.3 to SMF 2
I used those 2 files mentioned in this thread...

[Norv]

Cheers, good to hear, and welcome to SMF!