MySQL full backup and recovery

There are two ways to fully backup MySQL:

1. Packaging a folder backup with tar
   Installing the XZ compression Format tool: Yum–y install XZ
   Package The database folder: Tar jcvf/opt/mysql-$ (date +%f). tar.xz/usr/local/mysql/data/
2. Backing up with the Mysqldump tool
   Mysqldump-u root–p Database name >/backup path
   Mysqldump-u root–p––databases Database 1 Database 2 >/backup path
   Mysqldump-u root–p database name data table name >/backup path
   There are two methods of MySQL recovery:
   Use the source command (in MySQL database)
   Using the MySQL command (in Linux)

MySQL full backup and recovery