Impex - What do you put for 'server'?

[93Corvette]

I thought I'd put my Impex question here, since I've already had 52 views on VBulletin.com
and not a single responce for 24 hours.

My question is:

1. Do you use the Cpanel user name and password for Impex or do you use the MySQL password that you created?

2. I know most people use 'localhost' for the 'server'. But suppose the phpbb database is not on your local host, what do you put here? A IP address? A URL?

[Floris]

What is the variable it's asking you to fill in?

[93Corvette]

Originally Posted by Floris

What is the variable it's asking you to fill in?

Thanks for helping me Floris....

Here is what I have. I'm trying to move a forum called "audicar" which is a phpbb2 to a new vb3 forum called "vwcar". These are not actual sites, I'm just using them for examples.

I just don't know what the values should be in the ImPexConfig.php file. I made the following changes in red. I never made any changes to the Target section since the manual says not too. I put the note below with the link.
http://www.vbulletin.com/docs/html/impex_config
is says
"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']['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'; Example '216.86.13.10'
$impexconfig['source']['user'] = 'username'; I used my cpanel user name Example: audicar
$impexconfig['source']['password'] = 'password'; I used my cpanel password Example: Idontunderstand
$impexconfig['source']['database'] = 'source'; Example '_phpb3'
$impexconfig['source']['tableprefix'] = ''; I used '' (nothing)

I really appreciate your help....Thankyou.....

[Marco van Herwaarden]

You will need to enter the information to access the phpBB database. If it is not on the same server, then the server where it is hosted must allow external connections and this is usually disabled.

The easiest method would be to put the phpBB database (and files if attachments or such are stored on the filesystem) on your localhost and perform the migration locally. Once finished upload the new vBulletin database to your server.

[93Corvette]

Marco,
Thanks.... I will move the files to my localhost and try it from there tonight. Beleive me, when you said the "easiest method", that's me. Whatever is easier is my style.

I will keep you guys posted on the outcome.
Thank-you~

[Floris]

Just export the .sql of phpBB, put it on the same server as the vBulletin one is running, in a new db. And then use impex. You don't need the phpBB files.