Recover Backup File to Self-created Database

You can recover the backup data of JCS for Percona instance to the self-build database.

Precautions

The version of self-created database needs to be consistent with that of source database of backup file.
The backup unzip software only supports execution under Linux.
System software dependencies of unzip tool: tee, python version>= 2.7.
Percona xtrabackup has been installed on the current system; If it is not installed, see Official manual.
- For MySQL 8.0, xtrabackup >= 8.0.14 is required;
- For MySQL 5.6 and 5.7, xtrabackup >= 2.4.8 is required;
- For MariaDB 10.2, xtrabackup >= 2.4.8 is required;
- For Percona 5.7, xtrabackup >= 2.4.9 is required;

Operation instructions

For the install environmental dependence, see precautions DB.

Download the backup decompression tool Click to Download and decompress with the tool name of 'mysql_backup_extract.py', the use example is shown as bellow


  # Add executable permissions for unzip tool files
  chmod mysql_backup_extract.py +x
 
  # View help manual
  python mysql_backup_extract.py -h
  
  # Unzipping backup data of Percona service instance
  python mysql_backup_extract.py  -v 5.7 -f ./backup.xbstream

Download Backup File


 wget -c '<Data backup download address>' -O <Customize backup file name>.xbstream

 -c: Start breakpoint upload
 -O: Save the downloads as the specified file. Note that the suffix of the file must be .xbstream.

Decompress the backup data and the decompressed files in the sub-directory tmp_snapshot of current directory. It assumes that the current directory is $HOME.


  python mysql_backup_extract.py -v 5.7 -f <Customize backup file name>.xbstream
 
  -v Parameters may not be assigned, the default is: 5.7, and view the -h Help Manual for details of variables following -v.

Restore decompressed backup file. There are multiple configuration files in the tools, you can use it according to the actual instance type and version, see the following table for the correspondence.

Instance type and version Configuration file selection

MySQL 5.5、5.6、5.7 mysql-5.cnf

MySQL 8.0 mysql-8.cnf

MariaDB mariadb-10.2.cnf

Percona percona-7.cnf

<pre>[karsa]
xtrabackup --defaults-file=$HOME/percona-7.cnf --parallel=1 --prepare --target-dir=$HOME/tmp_snapshot
</pre>   

When you see ***innobackupex completed OK!***, it means that the execution is successful. You can go on to the next operation.

Modify file owner and confirm that the file belongs to MySQL user
复制成功
```
chown -R mysql:mysql $HOME/tmp_snapshot
```

Start Percona process.


mysqld_safe --defaults-file=$HOME/percona-7.cnf --user=mysql --datadir=$HOME/tmp_snapshot &

Login to Percona database
复制成功
```
mysql -uroot -p
```

The default password is null, please directly press return key.

Recover Backup to Self-created Percona

Products

开始与售前顾问沟通

可直接拨打电话 400-098-8505转1