MySQL Forums
Forum List  »  Security

How to move the encryption tables to another mysql server?
Posted by: jongse park
Date: June 23, 2016 01:57AM

Hi,

How to move the encryption tables to another mysql server?

I configured the MySQL Keyring for encryption.
But I can't move those encryption talbes to another mysql server.

server 1 : window mysql server
server 2: Linux mysql server

Those are file-per-table tablespaces

my.cnf
--------------------------------------------------------
[mysqld]
early-plugin-load=keyring_file.so
keyring_file_data=/usr/local/mysql/mysql-keyring/keyring
---------------------------------------------------------

mysql> SELECT PLUGIN_NAME, PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS
-> WHERE PLUGIN_NAME LIKE 'keyring%';
+--------------+---------------+
| PLUGIN_NAME | PLUGIN_STATUS |
+--------------+---------------+
| keyring_file | ACTIVE |
+--------------+---------------+


How to move the encryption tables to another mysql server?


Help me

Options: ReplyQuote


Subject
Views
Written By
Posted
How to move the encryption tables to another mysql server?
1841
June 23, 2016 01:57AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.