Download MySQL database for a single account by restore date using SSH

Sunlander

Well-Known Member
May 7, 2018
49
4
8
UK
cPanel Access Level
Root Administrator
Hi,

I need to download a MySQL database for a single account from a particular restore date in 2018 - the file does exist as can see the date/account under Backup/restore. I don't want to restore an entire account but need to access the database to retrieve some missing tables. I can see in WHM Backup and Restore I can restore databases for a single account by date, but I can't see any way to restore it to a different location so it doesn't wipe out my current version of the account. Is there any way to either download the required database that is backed up in cpanel, or telling it to restore to an alternative temp location so I can gain access to it?

I have not found a way to do this in your forums/docs (yet)

Any guidance would be most appreciated.
 

cPanelLauren

Product Owner
Staff member
Nov 14, 2017
13,304
1,250
313
Houston
Hello,


You wouldn't be able to restore a database's tables this way, but all the backups listed here are backups that are available in the default backup directory. To restore what you're looking to do, you'd need to download the full backup from the backup directory set in WHM>>Backup>>Backup Configuration and grab the database from that backup.