MySQL Database Restoration from Full Backup

osirion

Well-Known Member
Jan 16, 2007
67
7
158
Hi Guys,
So I have a customer with a full backup. How do I go about (through WHM or CLI) restoring a specific database within the full backup to his account?
 

Eminds

Well-Known Member
Nov 10, 2016
319
34
28
India
cPanel Access Level
Root Administrator
A full backup means a .tar.gz file , you will have untar the file first >> locate the mysql database.sql file and restore that file to the database , you can get the commands from google so its an easy stuff
 

osirion

Well-Known Member
Jan 16, 2007
67
7
158
Thanks - this is what I ended up doing. Was hoping there was a quicker /easier way for future reference, but guess not.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,880
2,267
463
Hello,

I'm happy to see you were able to restore the database. There's no other method of obtaining the SQL file other than extracting it from the full backup archive unless you have a backup of the database itself.

Thank you.