Can't export my database from mysql workbench
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.
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.
It is due to a flag that is by default "enabled" in mysqldump 8.
That can be disabled by adding --column-statistics=0.
Syntax :
mysqldump --column-statistics=0 --host=<server> --user <user> --password <securepass>
For more info please go to link
To disable column statistics by default, you can add
[mysqldump]
column-statistics=0
to a MySQL config file, such as /etc/my.cnf or ~/.my.cnf.