How to restore a mySQL database using phpMyAdmin

Discussion in 'MySQL' started by Davey Crocket, Apr 24, 2006.

0
  1. #1
    I'm moving servers, and I want to restore my database. Now in the new Cpanel its a blank slate no database or anything. Am I suppost to create the same name and password for the database name? Or can I create a new name and password?


     
    Davey Crocket, Apr 24, 2006 IP
  2. INV

    INV Peon

    Messages:
    1,686
    Likes Received:
    101
    Best Answers:
    0
    Trophy Points:
    0
    #2
    You could create any database name and user+pass to connect to it. However by doing that you just need to change the new info in your website config file that connects to the database.

    After creating the blank database you can goto PHPmyAdmin and click on SQL at the top and import your backup.

    However, its always better to use SHELL to import your database because phpmyadmin will timeout with large databases.
     
    INV, Apr 24, 2006 IP
  3. Skribblez

    Skribblez Notable Member

    Messages:
    5,939
    Likes Received:
    208
    Best Answers:
    0
    Trophy Points:
    280
    #3
    Skribblez, Apr 25, 2006 IP
  4. dcristo

    dcristo Illustrious Member

    Messages:
    19,776
    Likes Received:
    1,200
    Best Answers:
    7
    Trophy Points:
    470
    Articles:
    7
    #4
    Create a cpanel backup of the database on the old servers, the proceed to restore the SQL backup on the new server. It creates the db name for you. Then it's just a matter of adding the same db user/password and you should be sweet.
     
    dcristo, Apr 25, 2006 IP