Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Where is the database in a full backup?

Discussion in 'Data Protection' started by guedzzz, Jan 11, 2019.

  1. guedzzz

    guedzzz Registered

    Joined:
    Dec 9, 2018
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    United States
    cPanel Access Level:
    Website Owner
    Hey, I cancel a hosting account and forgot to migrate the DB, but I have a full cpanel backup. Is it possible to recover the data tables for that site somewhere? I have all the files for the wordpress I want to recover, but only missing the most important thing. Thanks in advance for your help!
     
  2. GOT

    GOT Get Proactive! PartnerNOC

    Joined:
    Apr 8, 2003
    Messages:
    1,478
    Likes Received:
    185
    Trophy Points:
    193
    Location:
    Chesapeake, VA
    cPanel Access Level:
    DataCenter Provider
    You can extract the archive and in the archive is a mysql folder which will have SQL dump files of all the databases for that account.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    DennisMidjord likes this.
  3. guedzzz

    guedzzz Registered

    Joined:
    Dec 9, 2018
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    United States
    cPanel Access Level:
    Website Owner
    Thank you! Just found out it didn't gave me a backup of the mysql :/

    I'll have to deal with starting again or reconnecting the links (manually?).

    Thanks anyways.
     
  4. GOT

    GOT Get Proactive! PartnerNOC

    Joined:
    Apr 8, 2003
    Messages:
    1,478
    Likes Received:
    185
    Trophy Points:
    193
    Location:
    Chesapeake, VA
    cPanel Access Level:
    DataCenter Provider
    You might want to look in whm phpmyadmin and see if the database is still there. Thing is if it was tied to the cpanel account then it should have gotten backed up when you did the full account backup. If it's not in the backup then MAYBE it wasnt tied to the cpanel account and if so when you terminated it it would have left the database there.

    It's a long shot but worth looking.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  5. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    47,335
    Likes Received:
    2,162
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello @guedzzz,

    Can you let us know what you see when manually extracting the .tar.gz backup archive that was downloaded from cPanel on the prior hosting provider's server?

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice