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 .
They give incorrect information there all the time, it's ridiculous.
Sorry, but in this instance it is correct. If you have albums/attachments and you use this method to downgrade, you will have problems afterwards. There are database changes between vb3 and vb4 for the way albums and attachments are stored.
12-11-2010, 10:00 PM
12-22-2010, 03:37 PM
