Get the App
SLTechnology News&Howtos  ›  Database  › 

How to solve the error of MariaDB server when backing up data in MySQL Workbench

Shulou Source: shulou.com Published: 2022-06-01 09:47:11 11月12日 Update

The server is running on MariaDB 10.2, and an error occurred while using MySQL Workbench:

Mysqldump: Couldn't execute 'SELECT COLUMN_NAME, JSON_EXTRACT (HISTOGRAM,' $. "number-of-buckets-specified"') FROM information_schema.COLUMN_STATISTICS WHERE SCHEMA_NAME = 'mls' AND TABLE_NAME =' office';': Unknown table 'COLUMN_STATISTICS' in information_schema (1109)

It seems that the version of mysqldump used by MySQL Workbench is not compatible with the version of the server.

You can now unpack MariaDB's ZIP package and send it to your local machine.

Then configure the dump program that comes with MariaDB on MySQL Workbench.

Https://www.cwiki.us/display/MariaDB/questions/41680979/mariadb-%E6%9C%8D%E5%8A%A1%E5%99%A8%E5%9C%A8-mysql-workbench-%E5%A4%87%E4%BB%BD%E6%95%B0%E6%8D%AE%E7%9A%84%E6%97%B6%E5%80%99%E5%87%BA%E9%94%99

Tags: Server service version machine program error problem face run configuration backup data time Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Huawei Shulou Tech Info Xiaomi Redmi MySQL