Announcement

Collapse
No announcement yet.

Can't run impex with orther port mysql ..

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Can't run impex with orther port mysql ..

    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.
    Last edited by MarsNIIT; Sat 10 Feb '07, 9:50pm.

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

    You need to use the correct db name.
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment


    • #3
      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.

      Comment


      • #4
        As you put in your ImpExConfig.php :

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

        That will connect on the port you want.
        I wrote ImpEx.

        Blog | Me

        Comment


        • #5
          - 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.

          Comment

          widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
          Working...
          X