The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-16. For the latest, interactive version please visit https://mariadb.com/kb/.

Export Table / Error?

Hello,

i want to export a table from my MariaDB (v10.3.24) -

I tried the export (only schema) with MySQL Workbench 8.0. but it is not working and i get an error-message: 16:52:58 Dumping stockdb (index_main) Running: mysqldump.exe --defaults-file="c:\users\polzi\appdata\local\temp\tmpkep_i2.cnf" --user=root --host=localhost --protocol=tcp --port=3306 --default-character-set=utf8 --no-data --skip-triggers "stockdb" "index_main" mysqldump: Couldn't execute 'SELECT COLUMN_NAME, JSON_EXTRACT(HISTOGRAM, '$."number-of-buckets-specified"') FROM information_schema.COLUMN_STATISTICS WHERE SCHEMA_NAME = 'stockdb' AND TABLE_NAME = 'index_main';': Unknown table 'column_statistics' in information_schema (1109)

Operation failed with exitcode 2 16:52:59 Export of C:\Users\Polzi\Documents\dumps\Dump20201002 (1) has finished with 1 errors

How can i export a table (1 for schema and 1 for data)?

Answer Answered by Ian Gilfillan in this comment.

COLUMN_STATISTICS does not exist in MariaDB, so where does that query come from? Perhaps a MySQL-version of mysqldump, or something added by MySQL Workbench?

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.