Uploading mysql databases in cpanel

Discussion in 'Databases' started by v4vikaskatoch, Feb 28, 2011.

0
  1. #1
    I did a full backup on my old host which stored all my html and mysql documents. The mysql files are stored as .sql files. On the new host, in the backup section of cpanel it has a spot to upload databases. I keep trying to upload these .sql files and it says "Restoring database" after it uploads and that's it.

    I reload my cpanel page and it never shows the databases I uploaded. Then I figured i might have to manually create the databases and THEN upload them, but it never uploads them. The database always appears as empty.

    The sql files are not empty. Any ideas?
     
    v4vikaskatoch, Feb 28, 2011 IP
  2. PsHouse

    PsHouse Peon

    Messages:
    12
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    How big is your db? Maybe you need to wait a bit longer for it to finish its work.
     
    PsHouse, Mar 1, 2011 IP
  3. phprocker

    phprocker Peon

    Messages:
    7
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    If you want still help, pls contact me.
     
    phprocker, Mar 1, 2011 IP
  4. dcristo

    dcristo Illustrious Member

    Messages:
    19,776
    Likes Received:
    1,200
    Best Answers:
    7
    Trophy Points:
    470
    Articles:
    7
    #4
    Create the database/user and then import the database file with phpMyAdmin.
     
    dcristo, Mar 1, 2011 IP