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

sparek-3

Well-Known Member
Aug 10, 2002
2,019
226
368
cPanel Access Level
Root Administrator
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

Member
Oct 10, 2003
19
0
151
San Francisco
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. :D
 

simplybe

Well-Known Member
Nov 29, 2002
153
0
166
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