MySQL Forums
Forum List  »  Newbie

Unknown table 'COLUMN_STATISTICS'
Posted by: Eran Yasso
Date: August 26, 2018 11:36AM

Hi,

I am trying to export my db using workbench.
I am getting before message box that my mysqldumo.exe is version 8.0.12, but the MySQL server to be dump has version 5.7.22.

When export ends (with failure) I am getting this error: "mysqldump: Couldn't execute 'SELECT COLUMN_NAME, JSON_EXTRACT(HISTOGRAM, '$."number-of-buckets-specified"') FROM information_schema.COLUMN_STATISTICS WHERE SCHEMA_NAME = 'SoLMySqlDB' AND TABLE_NAME = 'finalizedOrderLines';': Unknown table 'COLUMN_STATISTICS' in information_schema (1109)

Operation failed with exitcode 2"

Any work around?
I must backup the schema and the data of our database.
Thanks,

Options: ReplyQuote


Subject
Written By
Posted
Unknown table 'COLUMN_STATISTICS'
August 26, 2018 11:36AM


Sorry, only registered users may post in this forum.

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.