Restore failed

MySQL & MariaDB Percona XtraBackup
1

database version: Server version: 8.0.15 MySQL Community Server - GPL
xtrabackup version: 8.0.5

this is error message:
Encryption can’t find master key, please check the keyring plugin is loaded.
Encryption information in datafile: ./XXXX/XXXX.ibd can’t be decrypted, please confirm the keyfile is match and keyring plugin is loaded.
Encryption can’t find master key, please check the keyring plugin is loaded.
Encryption information in datafile: ./XXXX/XXXX.ibd can’t be decrypted, please confirm the keyfile is match and keyring plugin is loaded.
xtrabackup: Last MySQL binlog file position 12094478, file name binlog.000050

I have already use follow:
–xtrabackup-plugin-dir=/usr/local/mysql/lib/plugin
–keyring-file-data=“/usr/local/mysql/key/keyring”

:frowning:

2

Hello Stone, I’m just seeing if I can get any suggestions for you. What’s your situation please? e.g. are you in development or production and what environment are you working in?
Thanks

3

Hello Stone,
Please make sure that --xtrabackup-plugin-dir points to the directory containing keyring plugins which come with xtrabackup, not the mysql server ones. Have you backed up the keyring file at the same time you backed up the data? It is possible that keyring file no longer contains needed master keys due to master key rotation.