Export Table / Error?

You are viewing an old version of this question. View the current version here.

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

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?

Comments

Comments loading...
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.