How can I restore a backup from a specific day?

[PumpinIron]

I've got my own dedicated server that I lease through HostGator. It's running the latest version of WHM.

I have a site on that server and I need to restore the database form a few days ago (my server does backups every night). When I login as root and go to Backup > Restore Backup > Daily, it let's me choose the user I want to restore (as well as a host of other options) but it doesn't let me choose what date I want to restore it to.

I find this a little odd... Is there any way to restore a backup from a specific day?

 

[Infopro]

That depends on the version of cPanel that server is running I would think. New backup options have just been introduced that do permit this. (specific days)
If you're not using that new system, you'll need to grab a prior backup, unpack it and locate the mysql directory which contains your databases and restore the .sql file itself.

 

[PumpinIron]

I'm using 11.36.1 Build 6. Any idea whether that has these new backup features to mentioned?

 

[Infopro]

It does not.

 

[PumpinIron]

Okay thanks!

In order to grab a backup from a specific day do I have to use SSH and login as root to do it? There's no GUI interface to grab the backups I assume?

I only ask because I'm not super savvy with the command line.

 

[livelovesurveys]

Call the host. I use hostgator too and they can back it up to pretty much anything i ask.

 

[PumpinIron]

Call the host. I use hostgator too and they can back it up to pretty much anything i ask.

Will do! Thanks!

 

[sp3ctre69]

That depends on the version of cPanel that server is running I would think. New backup options have just been introduced that do permit this. (specific days)

Just found that, I didn't know about it... that is going to be really useful, thanks!