MYSQL WORKBECH - MAIN ERROR: Invalid options, MEB would not be able backup encrypted tables

(Doc ID 2330667.1)

Last updated on NOVEMBER 21, 2017

Applies to:

MySQL Workbench - Version 5.2 to 7.0 [Release 5.2 to 7.0]
Information in this document applies to any platform.

Symptoms

Configuring MySQL Enterprise Backup

Installed MySQL WorkBench and set up a connection to our MySQL Server. The MEB is installed on the MySQL server and seems to be all working fine.
The MySQL Server is encrypted using TDE. When backing up via WorkBench get a error:

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

IMPORTANT: Please check that mysqlbackup run completes successfully.
  At the end of a successful 'backup-and-apply-log' run mysqlbackup
  prints "mysqlbackup completed OK!".

170519 00:00:01 MAIN INFO: Encryption password "encrypt-password" not specified.
170519 00:00:01 MAIN ERROR: Invalid options, MEB would not be able backup encrypted tables.

mysqlbackup failed with errors!
170519 00:00:01 MAIN INFO: Setting server system variable 'old_alter_table' back to '0'.

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms