restoring a cpanel database backup

Discussion in 'Site & Server Administration' started by daboss, Sep 27, 2006.

  1. #1
    1. i go to hosting account A and perform a database backup using cpanel - it generated a .gz file which was downloaded to my pc

    2. i then logged into hosting account B to try to restore the database backup using cpanel also. the web page refreshed and displayed "restoring backup". unfortunately, it just stopped there. after many many minutes, i gave up and checked - the database was created but no tables or records were created. the database backup is very small - the entire .gz file is only 25kb.

    anyone can help tell me what went wrong and what i should do?
     
    daboss, Sep 27, 2006 IP
  2. noppid

    noppid gunnin' for the quota

    Messages:
    4,246
    Likes Received:
    232
    Best Answers:
    0
    Trophy Points:
    135
    #2
    Why don't you try using the phpmyadmin feature in cpanel if that's not what you are using?
     
    noppid, Sep 27, 2006 IP
  3. daboss

    daboss Guest

    Messages:
    2,249
    Likes Received:
    151
    Best Answers:
    0
    Trophy Points:
    0
    #3
    not sure what you mean. care to elaborate?

    i did a backup using cpanel and tried restoring the backup using cpanel. unfortunately, it didn't work and just 'hang'ed. nor sure how phpmyadmin comes into the picture. you mean i can use phpmyadmin to restore the backup created using cpanel? :confused:
     
    daboss, Sep 27, 2006 IP
  4. noppid

    noppid gunnin' for the quota

    Messages:
    4,246
    Likes Received:
    232
    Best Answers:
    0
    Trophy Points:
    135
    #4
    Well, you summed up by saying the database is only 25K. Thus, I made an assumption that a mysql database was what you are trying to move, not a whole account.

    If it's a whole account, then I'm at a loss for suggestions.

    But if it's just a database move, under databases at the very bottom should be a link to phpmyadmin which you can do database backup and restores with.
     
    noppid, Sep 27, 2006 IP
    daboss likes this.
  5. daboss

    daboss Guest

    Messages:
    2,249
    Likes Received:
    151
    Best Answers:
    0
    Trophy Points:
    0
    #5
    i guess i'm not writing coherently today... :)

    yes, i'm only doing a database move. i created the database backup using cpanel (which allows me to choose whether i want to do a full site backup or only the database backup). i tried restoring the database backup in cpanel and it didn't work.

    ok - i guess i can try doing the backup in phpmyadmin (didn't know that it had this feature)... ;)

    thanks!
     
    daboss, Sep 27, 2006 IP
  6. noppid

    noppid gunnin' for the quota

    Messages:
    4,246
    Likes Received:
    232
    Best Answers:
    0
    Trophy Points:
    135
    #6
    Glad to help. Holler back if you get stuck. There are many people here that can and will help if necessary.
     
    noppid, Sep 27, 2006 IP
  7. daboss

    daboss Guest

    Messages:
    2,249
    Likes Received:
    151
    Best Answers:
    0
    Trophy Points:
    0
    #7
    ah... i went over to phpmyadmin to have a look - there's a limit to the number of lines in the export file (50 k)??? i have a bigger database move to perform later and this won't work.

    anyone know how the database move can be made using the cpanel backup feature?
     
    daboss, Sep 27, 2006 IP
  8. Mike32

    Mike32 Guest

    Messages:
    17
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #8
    if you email your host and explain phpmyadmin wont work due to the filesize they should be willing to import the database for you through the servers console... its a fairly easy process for them to do
     
    Mike32, Sep 29, 2006 IP
  9. cpsitesaver.com

    cpsitesaver.com Peon

    Messages:
    20
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #9
    Why dont you try hiring an expert programmer for that? If this is too critical for you, maybe a helping hand can ease up the job.

    There are many programmers waiting at scriptlance.com.

    I have had the same problem before and the guy I hired here fixed it quickly in less than 20 bucks. Let them bid on it and you'll see.

    Hope this helps.
     
    cpsitesaver.com, Oct 8, 2006 IP
  10. saadahmed007

    saadahmed007 Admínistratör

    Messages:
    5,272
    Likes Received:
    869
    Best Answers:
    0
    Trophy Points:
    380
    #10
    Just go to cpanel create database same name suppose you had database ali on account A then create database with same name ali then go to phpmyadmin and try import :)
    Thanks,
    Saad
     
    saadahmed007, Oct 8, 2006 IP