My Oracle Support Banner

Mysqldump Backup Restore Fails When Pulling From A Server With Keyring Active (Doc ID 2909647.1)

Last updated on NOVEMBER 15, 2022

Applies to:

MySQL Server - Version 8.0 and later
Information in this document applies to any platform.
The restore is being done to a MySQL Server instance that is not running any encryption component/plugins.

Symptoms

On : 8.0 version, Plugin API

mysqldump backup restore fails when pulling from a server with keyring_okv ACTIVE

Getting several errors like this when restoring data from a dump from a server OKV activated:


ERROR
-----------------------

ERROR 3185 (HY000): Can't find master key from keyring, please check in the server log if a keyring is loaded and initialized successfully.
Query OK, 0 rows affected, 1 warning (0.00 sec)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Add keyring to encrypt source instance
2. Use mysqldump to do a logical dump
3. Attempt to import logical dump back into an instance not using encryption

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot get their data imported into new server.

Changes

 The restore is being done to a MySQL Server instance that is not running any encryption component/plugins.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.