Cannot connect to database

[ppokyh]

Hi I cannot connect to my database. It says "cannot connect to source: check username and password". I have done this and it is correct

Here are my settings
$impexconfig['target']['databasetype'] = 'mysql';
$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;

# mysql / mssql
$impexconfig['source']['databasetype'] = 'mysql';
$impexconfig['source']['server'] = 'localhost';
$impexconfig['source']['user'] = 'paradise_phpb1';
$impexconfig['source']['password'] = 'x';
$impexconfig['source']['database'] = 'paradise_phpb1';
$impexconfig['source']['tableprefix'] = 'phpbb_';


I have not moved the phpbb2 "db" to the same server as where the vb is, is this my problem? If so, how do I find the exact files to upload and which folder do I upload it to? I already have 1000 members in my vbulletin I need to add another 800 from phpbb, is that going to be a problem to merge them? Sorry for the ramble I'm on to 8 hours trying to get this fixed

[Marco van Herwaarden]

If your phpBB database is not located on teh same server, then you will need to set the correct servername for:
$impexconfig['source']['server'] = 'localhost';

Please note that most servers do not allow external connections to the database, and this will probably not work.

If external connections are not allowed to the old database, then teh best solution is to create a MySQL backup from the old database, create a new temporary database on the new server, and restore the backup into that.

For instructions on how to backup and restore a database see:
Backing-up your MySQL Database Manually (http://www.vbulletin.com/docs/html/main/manual_database_backup)
Restoring your MySQL Database Manually (http://www.vbulletin.com/docs/html/main/manual_database_restore)