Question
When using the cPanel Backup Feature, you can backup the entire MySQL data directory using the following option.
WHM: Home -> Backup -> Backup Configuration
This will create a full directory backup of the MySQL directory in your backup directory.
Example:
/backup/2020-08-13/system/dirs/_var_lib_mysql_.tar.gz
Once expanded, you will find the 'raw' MySQL database directories and files.
Example:
# tar -ztvf _var_lib_mysql_.tar.gz | grep cptest
drwxr-x--- mysql/mysql 0 2020-08-13 08:36 var/lib/mysql/cptest_cptest/
-rw-r----- mysql/mysql 65 2020-08-13 08:36 var/lib/mysql/cptest_cptest/db.opt
drwxr-x--- mysql/mysql 0 2020-08-13 08:38 var/lib/mysql/cptest3_cptest/
-rw-r----- mysql/mysql 65 2020-08-13 08:38 var/lib/mysql/cptest3_cptest/db.opt
drwxr-x--- mysql/mysql 0 2020-08-13 08:38 var/lib/mysql/cptest4_cptest/
-rw-r----- mysql/mysql 65 2020-08-13 08:38 var/lib/mysql/cptest4_cptest/db.opt
Comments
0 comments
Article is closed for comments.