How Do I Restore MySQL data from a Full Site Backup?

[StealthDesign]

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

[sparek-3]

I think there is a mysql directory in the tar.gz file. When you extract the tar.gz file, move the contents of that mysql directory into /var/lib/mysql . I believe this is the correct procedure. Its been a while since I manually restored a MySQL database, and I'm just going from memory.

[StealthDesign]

Originally posted by sparek-3
I think there is a mysql directory in the tar.gz file. When you extract the tar.gz file, move the contents of that mysql directory into /var/lib/mysql . I believe this is the correct procedure. Its been a while since I manually restored a MySQL database, and I'm just going from memory.

Thank you, I will give that a try. Once I figure out how to get SSH working that is.

[simplybe]

you will also need to chown the files and chmod them via ssh once you have uploaded them.

chown -R mysql.mysql /var/lib/mysql/user_dbname