Hi ,
One of the topics that most of webmasters talking about that is : How to downgrade from vBulletin 4.x.x to vBulletin 3.7 or 3.8 .
You can downgrade your vbulletin from 4.x to 3.x very very easy ! Without losing attachments , thanks , passwords .
You need IMPEX ( One of the vBulletin scripts like an addon ) to Do this work .
How to do this :
First of all you must get a backup ( export ) from attach and post_thanks table from your phpmyadmin ( in .sql format )
1. Get full backup from your vbulletin 4.x database .
2. Go to members.vbulletin.com and download IMPEX Script .
3. Make a new database and a new place for your new vbulletin ( 3.8) .
4. Install vbulletin 3.x ( 3.8.7 for example ) for your new database .
5. Extract the impex script and upload impex files ( in upload folder ) to your 3.8 forum root .
Now you have 2 databases . We call 4.x database old and 3.x database new .
6. You must config impex .
7. Go to impex folder in 3.x forum and rename ImpExConfig.php.new to ImpExConfig.php
After rename , Open and edit it :
Code:
####
#
# TARGET - The target is the vBulletin database (where the data is going to)
#
####
$impexconfig['target']['server'] = 'localhost';
$impexconfig['target']['user'] = 'username';
$impexconfig['target']['password'] = 'password';
$impexconfig['target']['database'] = 'vbulletin_forum';
$impexconfig['target']['tableprefix'] = '';
# If the system that is being imported from uses a database,
# enter the details for it here and set 'sourceexists' to true.
# If the source data is NOT stored in a database, set 'sourceexists' to false
$impexconfig['sourceexists'] = true;
####
#
# SOURCE - The source is the old forum database (where the data is coming from)
#
####
# mysql / mssql
$impexconfig['source']['databasetype'] = 'mysql'; // mysql OR mssql
$impexconfig['source']['server'] = 'localhost';
$impexconfig['source']['user'] = 'username';
$impexconfig['source']['password'] = 'password';
$impexconfig['source']['database'] = 'source';
$impexconfig['source']['tableprefix'] = '';
You must set 3.x database informations in TARGET
And set 4.x database informations in SOURCE
8. Go to vbulletin 3 admincp --> Login --> You must have a new tab "Import"
9. Click on Import tab then you will see import page.
Select system : Choose 3.7.x
Select version and product : Choose vBulletin 3.7 and 3.8
Start all of the modules .
After you do this work you must go to update counters and update all of counters.
After all of this works you must import post_thanks and attach table . ( then optimize tables)
Thank you & Be successful .
What about attachments? As far as I can see, you will lose any attachments using this method (and album images also). The database structure was changed for attachments and album images between 3.x and 4.x.
@Lynne , You can save your attachments in host then import it In impex .
--
I test it and it works
I don't see how that will work. If you now have all album images mixed in with the attachments, how can doing an import put them all back into the correct place?
Admittedly, I have not tried this, but I don't see how it would work.
You can also convert to another board like mybb or phpbb3. From there you an use impex system. I guess you will loose the members password by doing so.
12-11-2010, 10:00 PM
12-13-2010, 02:37 AM
