Can't export my database from mysql workbench
I am trying to export my database from MySQL Workbench but I get this during the export progress:
Running: mysqldump.exe --defaults-file="c:\users\user\appdata\local\temp\tmp2h91wa.cnf" --user=root --host=localhost --protocol=tcp --port=3306 --default-character-set=utf8 --skip-triggers "mydb" mysqldump: Couldn't execute 'SELECT COLUMN_NAME,
JSON_EXTRACT(HISTOGRAM, '$."number-of-buckets-specified"')
FROM information_schema.COLUMN_STATISTICS WHERE SCHEMA_NAME = 'mydb' AND TABLE_NAME = 'courses';': Unknown table 'column_statistics' in information_schema (1109)Operation failed with exitcode 2 20:55:09 Export of C:\Users\user\Documents\dumps\mydb.sql has finished with 1 errors
Also ran into this problem. Decided as follows: In the Workbench menu, go to:
Edit - Preferences - Administration
In the field "Path to mysqldump Tool", prescribe the path to mysqldump.exe, in my case "C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqldump.exe", click OK.
After that, the error no longer appeared.
In MySql Workbench version 8.0.13 do the following steps:
- Go to Management/Data export
- Choose the schema to export in the 'Tables to export' list
- Click the 'Advanced Options...' button (top right)
- Search for the option 'Other/column-statistics'
- Set the value to 0
- Click the 'Return' button (top right)
Now it should work. Unfortunately, you'll have to do that every time you start MySql Workbench.