Using Impex

[swisscotton]

I am about to install Impex. Can I just ask if I have to set up the categories and forums on my forum before transfer? Or dose the backup contain all of that data and I just use inpex?

[swisscotton]

By the way in the help document it says I should have a file called "ImpEx_versionnum_licensenum" after unzipping it. I don't. I have:

Upload
Impex read me
License Agreement


:confused:


When the unzipping progress is complete, you will find that the process has created a new folder called ImpEx_versionnum_licensenum (where versionnum is the version number of the package you have downloaded, and licensenum is the license number of your vBulletin license).

[Jose Amaral Rego]

Your question may get answered quicker if you were to have posting in this forum
vBulletin 3.6 Import System (http://www.vbulletin.com/forum/forumdisplay.php?f=92). You can ask to have your thread moved, just by reporting it or wait till someone with deeper knowledge to answer your question.

[swisscotton]

Ok forget the above. Looks like Vb have changed so you only see the needed files after it has been unzipped.

However I am stuck on what I have to edit in the php ImpExConfig.php file.

I want impex to run from admincp so I have missed Target Database Information out.

Who do I ask to get relevant info from?


$impexconfig['sourceexists'] 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['source']['databasetype'] Enter the type of database here, usually this is mysql. If you are importing from a MS-SQL database, you will need MS-SQL support in PHP

$impexconfig['source']['server'] This sets the address of database server from which you want to import data from. On most installations the database server is located on the same computer as the web server, in which case the address should be set to 'localhost', if this database is hosted on another domain use the address of the database server as supplied by your web host. If you are attempting to import from a remote server (i.e. you have just moved hosts) ensure that the database will allow remote connections. Other wise you will need to back up the source database and restore it on your new server so it is local.

$impexconfig['source']['user'] This variable contains the username provided to you by your host for connecting to your database server.

$impexconfig['source']['password'] The password that accompanies the database username should be entered here.

$impexconfig['source']['database'] This value should be altered to state the name of the database that contains your other forum software data on the database server.

$impexconfig['source']['tableprefix'] If that database uses a prefix for the tables, set it here.


I will ask to get this thread moved :)

[Jerry]

This info will help us answer :

http://www.vbulletin.com/forum/showthread.php?t=161907

[swisscotton]

Ok I am well and truely confused so any help you guys can give me would be VERY helpful. :eek:

I haven't uploaded the file yet as I am just amending it before upload.

• Type of import (clean or merge) : Clean
• Source: Invisionfree
• Target version. Vb 3.6.10
• Module issue occurred on.
• Any SQL error reported. (not yet – editing php file before upload)



Target Database Information (Into which database do we import?)

If you have ImpEx installed correctly and are running it via the admincp, you can ignore the target settings go to the source. This is because ImpEx will read you vBulletin config file.

$impexconfig['target']['databasetype'] Enter the type of database here, currently this can only be mysql

$impexconfig['target']['server']
This sets the address of your database server. On most installations the database server is located on the same computer as the web server, in which case the address should be set to 'localhost', otherwise use the address of the database server as supplied by your web host.

$impexconfig['target']['user']
This variable contains the username provided to you by your host for connecting to your database server.

$impexconfig['target']['password']
The password that accompanies the database username should be entered here.

$impexconfig['target']['database']
This value should be altered to state the name of the database that will contain your vBulletin installation on the database server.

$impexconfig['target']['tableprefix']
If your vBulletin installation uses a prefix on the tables, set it here.


Source Database Information (From which database do we import?)$impexconfig['sourceexists'] 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['source']['databasetype']
Enter the type of database here, usually this is mysql. If you are importing from a MS-SQL database, you will need MS-SQL support in PHP

$impexconfig['source']['server']
This sets the address of database server from which you want to import data from. On most installations the database server is located on the same computer as the web server, in which case the address should be set to 'localhost', if this database is hosted on another domain use the address of the database server as supplied by your web host. If you are attempting to import from a remote server (i.e. you have just moved hosts) ensure that the database will allow remote connections. Other wise you will need to back up the source database and restore it on your new server so it is local.

$impexconfig['source']['user']
This variable contains the username provided to you by your host for connecting to your database server.

$impexconfig['source']['password']
The password that accompanies the database username should be entered here.

$impexconfig['source']['database']
This value should be altered to state the name of the database that contains your other forum software data on the database server.

$impexconfig['source']['tableprefix']
If that database uses a prefix for the tables, set it here.


Defines for special cases (What do we want to turn off/on ?)

impexdebug
Prints out to the screen any debug added to an install of ImpEx.

emailcasesensitive
When matching emails in the user module (user merge), this forces the matching to be case sensitive or not (follwing the RFC strictly, emails should be case sensitive, for the vast majority of the time, this isn't the case).

forcesqlmode
Some MySQL servers that have MYSQL_STRICT mode, will not accept a lot of the ImpEx SQL as it currently uses the database defaults and not a value for even field, this attempts to override that setting by passing the SQL ' set sql_mode = '' '

skipparentids
The last set of updating post is setting the parent id's for the imported posts if they don't have one. This can be (and usually is) very intensive due to the amount of SQL used. The number of queries run is the number of threads times two, plus one. Though this is very effected by the number of posts as usually the post table has to be scanned (MySQL intensive).
Sometimes due to the load on larger boards the final page of the import posts can time out, setting this define to true will skip that all together. The load and bottle neck here is a know issue and being looked at.

[Jerry]

To set up an invisionfree import, you're going to need this :

http://www.vbulletin.com/forum/showpost.php?p=1084570&postcount=4

It's a database structure that you load your invision free data into, then import from there.

[swisscotton]

I do have the backup of my last board from IF in a php file.

I have uploaded Impex and followed all the instructions (to my knowledge) but for some reason cannot locate the import option in the admincp. I am using the latest version 3.6.10.


The only thing I can think of that I did wrong was the part in the php file as I didn't understand much of it. However most of it I left as it was and just unput my username, password, database and user. Its uploaded and sitting in the admincp folder.

[Jerry]

I do have the backup of my last board from IF in a php file.

A PHP file ? Likely that it isn't the back up.

Either way you have to restore the SQL backup to the database to create the source :

http://www.vbulletin.com/docs/html/main/manual_database_restore

http://www.vbulletin.com/forum/showpost.php?p=1084570&postcount=4

[swisscotton]

A PHP file ? Likely that it isn't the back up.

Either way you have to restore the SQL backup to the database to create the source :

http://www.vbulletin.com/docs/html/main/manual_database_restore

http://www.vbulletin.com/forum/showpost.php?p=1084570&postcount=4

Sorry I meant sql. I am compleatly new to this so I am very mixed up.

I have managed to do it but when I click on import i am getting a 404 Not Found error.

[Jerry]

Ensure that the impex/ folder and it's contents is uploaded to the vBulletin directory that has includes/ admincp/ etc in it.