Importing phpBB to vBulletin.

[cape kid]

Importing phpBB to clean upload of vBulletin.

Source - phpBB2 - 2.0.18

Target - vBulletin 3.5.0


I don't think I have any right to be playing with this stuff, it's way out of my league as I am just your average amateur website builder. I've read the installation manual and a whole host of forum threads but obviously I'm incapable of absorbing information that seems second nature to everyone else!

This may sound stupid but I don't even know what my 'target database' and 'source database' is! Which is why the IMPORT keeps telling me there is no such database.

Here's my Config.php


// ****** DATABASE TYPE ******
// This is the type of the database server on which your vBulletin database will be located.
// Valid options are mysql and mysqli, for slave support add _slave. Try to use mysqli if you are using PHP 5 and MySQL 4.1+
$config['Database']['dbtype'] = 'mysql';

// ****** DATABASE NAME ******
// This is the name of the database where your vBulletin will be located.
// This must be created by your webhost.
$config['Database']['dbname'] = 'forums';

// ****** TABLE PREFIX ******
// Prefix that your vBulletin tables have in the database.
$config['Database']['tableprefix'] = '';

// ****** TECHNICAL EMAIL ADDRESS ******
// If any database errors occur, they will be emailed to the address specified here.
// Leave this blank to not send any emails when there is a database error.
$config['Database']['technicalemail'] = 'admin@xxxxx.com';

// ****** FORCE EMPTY SQL MODE ******
// New versions of MySQL (4.1+) have introduced some behaviors that are
// incompatible with vBulletin. Setting this value to "true" disables those
// behaviors. You only need to modify this value if vBulletin recommends it.
$config['Database']['force_sql_mode'] = false;


// ****** MASTER DATABASE SERVER NAME AND PORT ******
// This is the hostname or IP address and port of the database server.
// If you are unsure of what to put here, leave the default values.
$config['MasterServer']['servername'] = 'mysql';
$config['MasterServer']['port'] = 3306;

// ****** MASTER DATABASE USERNAME & PASSWORD ******
// This is the username and password you use to access MySQL.
// These must be obtained through your webhost.
$config['MasterServer']['username'] = 'username@xxxxx.com';
$config['MasterServer']['password'] = 'REMOVED';


and here's my ImpExConfig.php



-------


ImPexConfig.php

$impexconfig['target']['server'] = 'mysql';
$impexconfig['target']['user'] = 'username@xxxxx.com';
$impexconfig['target']['password'] = 'REMOVED';
$impexconfig['target']['database'] = 'forums';(this is the folder my vBulletin index's from)
$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'] = 'mysql';
$impexconfig['source']['user'] = 'username@xxxxxx.com';
$impexconfig['source']['password'] = 'REMOVED';
$impexconfig['source']['database'] = 'forum'; (this is the folder that my phpbb index's from)
$impexconfig['source']['tableprefix'] = 'phpbb_';

####
#
# DUPLICATE CHECKING
# Where unique import id's are aviable ImpEx can check for duplicates with some
# Tier2 systems this will need to be set to false.
#
# yahoo_groups, YaBB 2.1
#
####

define('dupe_checking', true);I'm guesssing it's a target/source Db misunderstanding from my end. Can anyone set me straight?

Is 'forums' the correct target database name and 'forum' the correct source database? I feel that I'm way off the mark here.

Sorry for lack of ability on my part. Any guidance would be appreciated.


Cheers

[Steve Machol]

This is correct:


Source - phpBB2 - 2.0.18

Target - vBulletin 3.5.0
This, not so much:



$impexconfig['target']['database'] = 'forums';(this is the folder my vBulletin index's from)

$impexconfig['source']['database'] = 'forum'; (this is the folder that my phpbb index's from)


You need to use the names of the databases in MySQL, not the names of the folders.

[cape kid]

Thanks Steve,

Where do I find the names of the databases?

Is it something I would have set up myself or is it a database name purely created by my Yahoo webhost?

Yahoo Help says:

Your database, called mysql, will be created automatically.

But I thought that was the server instead of the standard 'localhost' in the Config.php file.


Both boards appear to run fine indepently, but I'm confused about what 'name' goes there for imports.


Sorry for the inconvenience.

[cape kid]

Throught phpMyAdmin right?

Obviously I must have set a database up at some stage if both boards are running.

[Steve Machol]

Yes, you can see the db names in phpMyAdmin. And of course the vB db name will also be in your includes/config.php file.

[antiekeradio]

'localhost' only indicates that the database server is running on the same physical computer as the web server program.


Obviously I must have set a database up at some stage if both boards are running.

very true. :D