Announcement

Collapse
No announcement yet.

Restoring the Database on the New Server WON'T WORK

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

  • Restoring the Database on the New Server WON'T WORK

    Hi,

    I'm trying to restore a mysql database dump (a phpBB sql dump to be exact, for import to vBulletin with ImpEx) as the documention specified, like this:

    mysql –uUSERNAME –p NEWDBNAME < /PATH/TO/NEW/DUMP.SQL

    I tried a tests before and it did work but now I'm getting an error stating:

    ERROR 1049: Unknown database 'NEWDBNAME'

    This is really frustrating please someone help out!!!

    Server Specs:

    Free BSD
    MySQL 4.0.17
    Apache 1.3.33
    Last edited by Collectors; Fri 21 Jan '05, 12:07pm.

  • #2
    You need to create a database with that name.

    Here is our online documentation for creating a new database and db user:

    http://www.vbulletin.com/docs/html/create_database

    And from the MySQL site:

    http://dev.mysql.com/doc/mysql/en/CREATE_DATABASE.html
    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
      Thank you for the ultra-fast reply!

      I made the 'NEWDBNAME' and it's returning a new error stating:

      ERROR 1007 at line 12: Can't create database 'NEWDBNAME'. Database exists

      Someone please give me a drink

      Comment


      • #4
        Looks like your dump tries to create the database too. Try dropping the database you just created, and using this command to restore it:

        mysql –uUSERNAME –p < /PATH/TO/NEW/DUMP.SQL

        Comment


        • #5
          Working!

          Originally posted by Mike Sullivan
          Looks like your dump tries to create the database too. Try dropping the database you just created, and using this command to restore it:

          mysql –uUSERNAME –p < /PATH/TO/NEW/DUMP.SQL
          This works!
          Last edited by Collectors; Fri 21 Jan '05, 1:35pm.

          Comment


          • #6
            It works!

            Originally posted by Mike Sullivan
            Looks like your dump tries to create the database too. Try dropping the database you just created, and using this command to restore it:

            mysql –uUSERNAME –p < /PATH/TO/NEW/DUMP.SQL
            Special thanks to Mike Sullivan and Steve Machol, Excellent work

            Cheers!

            Comment

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