Where is the database in a full backup?

guedzzz

• January 11, 2019 14:58

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!

• 

  GOT

  • January 11, 2019 23:37

  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.

  0
• 

  guedzzz

  • January 11, 2019 23:41

  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.

  0
• 

  GOT

  • January 12, 2019 01:39

  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.

  0
• 

  cPanelMichael

  • January 14, 2019 16:53

  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.

  0

Please sign in to leave a comment.