Restore ONLY a MySQL db without restoring anything else?

[sneader]

I have a customer that deleted a MySQL db from cPanel, by accident. They would like that db restored from the daily backup, but they don't want the rest of their directory overwritten or mail overwritten.

In the "Restore Backup" in WHM, you can uncheck "restore mail config" which I believe will leave e-mail untouched. And you can check/uncheck Restore MySQL dbs if you want to control whether MySQL dbs are restored.... but is there any way to just do the MySQL dbs without restoring anything else?

Also, for future reference, is there a way to restore only a SINGLE MySQL db, without restoring ALL dbs?

- Scott

 

[hzJayJ]

You can run the command to restore the database from the backup sql file through the shell

mysql database_name < database_name.sql