How do I restore a MySQL database which was backed up via cPanel's full site backup feature?

If you restore the entire site from the backup then cPanel will restore the mysql data automatically.

However, if you just want the MySQL DB restored then untar the backup file and look for a file ending in .sql. That should be all you need. If you don't know how to restore from a .sql file then google it or reply and maybe some1 will help you.

Michael

MySQL Backup

mysqldump -u root -p DBNAME > BKPNAME.sql

-----------

MySQL Restore

mysql -u root -p DBNAME < BKPNAME.sql

-----------

I have a bad sector on a drive that hosed up a customers mysql db.

I have carried over and uncompressed one of the sites backups. Viewing the backup data I was hoping to find a .sql file for the site. Instead there is a mysql directory with the databases in their own folders. Going into the folder of the database I would like to restore I see nothing but .frm, .MYD, .MYI files. How can I restore from this?


Thanks!

I figured it out.

Can you tell me how? I still don't get it.

Uncompress the backup into a tmp directory.
Within that in the mysql directory locate the db you would like to backup.
copy the contents into its associated directory in /var/lib/mysql/*dbname*

chown -R mysql.mysql /var/lib/mysql/*dbname*

didnt work for me.. any more ideas?