Announcement

Collapse
No announcement yet.

New Server, Old DB

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

  • New Server, Old DB

    Hi,

    I am moving our forums to a new server. I have a fresh installation of version 3 working on the new machine, but when I move the old database (running vBulletin version 2) from the old server over it stops working. I'm getting the following error:

    "Database error in vBulletin:

    cannot use database vBulletin
    mysql error: Unknown database vbulletin

    mysql error number: 1049"

    Apache & PHP are not my primary server/language, so please consider me a newbie.

    Thanks much,
    Starr

  • #2
    You need to edit config.php with all the new db info for that server.
    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
      Thanks, Steve. During the installation, I updated the config.php in htdocs\forums\includes as follows:

      $servername = 'localhost'; (Does this need to be the server IP?)
      $dbusername & $dbpassword - both set correctly
      $dbname = 'vBulletin';

      Is there anything else in that file I need to update?

      Starr

      Comment


      • #4
        Since the error is:

        mysql error: Unknown database vbulletin

        Then this line can't be correct:

        $dbname = 'vBulletin';
        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


        • #5
          Do you mean that 'vBulletin' needs to be changed, or that it could not be written this way if I'm getting that error? It's definitely written that way. Could the app be pointing to another config.php file? I checked the config.php file on the old box that is working and that setting is the same.

          As a test, I pointed $servername to the IP for the existing (working) database and got this:

          "Invalid SQL: <text of SELECT statement>

          mysql error: Table 'vbulletin.datastore' doesn't exist
          mysql error number 1146"

          Has the db structure changed from version 2 to 3?

          Thanks,
          Starr

          Comment


          • #6
            yes. Once you get the database information correct, you must runt he upgrade.php script in /install/upgrade.php and follow the steps in order.
            Shane
            CIO, FrakMedia.net
            Director of Information, BattlestarForum.com

            Comment


            • #7
              Morning,

              Attempting to run the upgrade script, I get (on Step 1):

              "Database error in vBulletin:

              Invalid SQL:
              CREATE TABLE calendar <text of SQL statement>

              mysql error: Can't create table '.\vbulletin\calendar.trm (errno:121)
              mysql error number: 1005"

              Thanks!
              Starr

              Comment


              • #8
                I've never seen that error before:

                System error: 121 = Remote I/O error
                MySQL error: 121 = Duplicate key on write or update

                You originally stated you were installing and now you say you are upgrading. Please clarify exactly what you are doing and have done.
                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


                • #9
                  I'm setting up a new server with version 3, but trying to move our old database from version 2 over to the new setup. Based on advice from Shane above I ran the upgrade script to convert the old db to the new format.

                  Comment


                  • #10
                    And where does the install come in?
                    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

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