Not the answer you need?
Register and ask your own question!

Restore failed

StoneStone EntrantCurrent User Role Novice
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”


:(

Comments

  • lorraine.pocklingtonlorraine.pocklington Percona Community Manager Legacy User Role Patron
    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
  • sergei.glushchenkosergei.glushchenko Percona Inactive User Role Novice
    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.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.