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

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.

 

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