Can't run impex with orther port mysql ..

[MarsNIIT]

Hello,

My server install:
- mysql server v4x port 3306: no database
- mysql server v5x port 3307: database name: marsdb_2ITForum

-- I had forum X use marsdb_2ITForum. Now i want create new forum Y use import database from marsdb_2ITForums. So i create database name 2IT_Forums in mysql server v5x port 3307.

When i use impex with impexconfig.php:


==================================
# For mysqli enter mysql
$impexconfig['target']['databasetype'] = 'mysql';
$impexconfig['target']['port'] = 'localhost:3307';
$impexconfig['target']['database'] = '2IT_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']['port'] = 'localhost:3307';
$impexconfig['source']['tableprefix'] = '_';
==================================

==> Error:

==================================
ImpEx Database errormysql error: cannot use database 2IT_Forums

mysql error: Unknown database '2it_forum'

mysql error number: 1049

Date: Wednesday 07th of February 2007 09:22:18 AM
Database: 2IT_Forums
MySQL error: Unknown database '2it_forum'
==================================


==> I think with current impexconfig.php ins't run with port 3307, only run with port 3306, so i try create new database name: 2it_forums in mysql v4x (port 3306) and Error:


==================================
ImpEx Database errormysql error: Invalid SQL: SELECT data FROM marsniit_datastore WHERE title = 'ImpExSession'

mysql error: Table '2it_forums.marsniit_datastore' doesn't exist

mysql error number: 1146

Date: Wednesday 07th of February 2007 09:32:35 AM
Database: 2IT_Forums
MySQL error: Table '2it_forums.marsniit_datastore' doesn't exist
==================================


Thanks.

[Steve Machol]

This means there is no database named: '2it_forums'

You need to use the correct db name.

[MarsNIIT]

Yes, this means there is no database named: '2it_forums'

Because:
==> I think with current impexconfig.php ins't run with port 3307 (i need run with port 3307 because it's mysql version 5), only run with port 3306, so i try create new database name: 2it_forums in mysql v4x (port 3306) and Error:


==================================
ImpEx Database errormysql error: Invalid SQL: SELECT data FROM marsniit_datastore WHERE title = 'ImpExSession'

mysql error: Table '2it_forums.marsniit_datastore' doesn't exist

mysql error number: 1146

Date: Wednesday 07th of February 2007 09:32:35 AM
Database: 2IT_Forums
MySQL error: Table '2it_forums.marsniit_datastore' doesn't exist
==================================


Thanks.

[Jerry]

As you put in your ImpExConfig.php :

$impexconfig['target']['port'] = 'localhost:3307';

That will connect on the port you want.

[MarsNIIT]

- My server installed 2 mysql server: port 3306 (version 4x) and por 3307 (version 5x)
- Both 'target' and 'target' database putted in the same server port 3307 (versin 5x)
- serer port 3306: not have any datbase exist *****
- serer port 3307: datbase of my old forum ('marsdb_2ITForum') and new forum (2it_forums)
- I installed 2it_forum finish wih info:
=======================
port: 'localhost:3307';
user: 'root';
password: 'xxxxx';
database: '2IT_Forum';
tableprefix: 'marsniit_';
=======================

- Now i want import data form old forum db: marsdb_2ITForum
I set my impexconfig:
==================================
# For mysqli enter mysql
$impexconfig['target']['databasetype'] = 'mysql';
$impexconfig['target']['port'] = 'localhost:3307';
$impexconfig['target']['user'] = 'root';
$impexconfig['target']['password'] = 'xxxxx';
$impexconfig['target']['database'] = '2IT_Forum';
$impexconfig['target']['tableprefix'] = 'marsniit_';
==================================

But it error:
==================================
ImpEx Database errormysql error: cannot use database 2IT_Forum
mysql error: Unknown database '2it_forum'
mysql error number: 1049
Date: Wednesday 07th of February 2007 09:22:18 AM
Database: 2IT_Forums
MySQL error: Unknown database '2it_forum'
==================================

You said that this error because user not permision and the can connect to mysql server.
Yes, can connect to mysql serer, but this connect to mysql server port 3306 (version 4x), not port 3307 (version 5x).
Because when i create new database name 2it_forum in mysql server port 3306 (version 4x) the error change to:
==================================
ImpEx Database errormysql error: Invalid SQL: SELECT data FROM marsniit_datastore WHERE title = 'ImpExSession'
mysql error: Table '2it_forum.marsniit_datastore' doesn't exist
mysql error number: 1146
Date: Wednesday 07th of February 2007 09:32:35 AM
Database: 2IT_Forum
MySQL error: Table '2it_forum.marsniit_datastore' doesn't exist
==================================

So, we see before i create db name: 2it_forum, this db not exist in mysql server port 3306, it error:"can't use database". And when i create db name 2it_forums, the error change, this mean can connect to db but table of vbb forum not exist .

>> This way can't connect to mysql server port 3307, only connect to 3306 (defaul mysql port)

Please help me check again.
Thanks.