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
The Data Export MySQL Workbench feature provides an inbuilt option to export the data into CSV format.
Use this wizard to either export or import SQL generated from MySQL Workbench or with the mysqldump command. Access these wizards from either the Navigator area of the sidebar, or by selecting Server from the main menu, and then either Data Import or Data Export.
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:
Now it should work. Unfortunately, you'll have to do that every time you start MySql Workbench.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With