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

I had the same issue 5 minutes ago.

I fixed it by adding in my `mysqldump` command `--column-statistics=0`.
Do it and it should work.

In my case it's a phing task but you should get the idea.

[![enter image description here][1]][1]


[1]:

In MySql Workbench version 8.0.13 do the following steps:

1. Go to Management/Data export
2. Choose the schema to export in the 'Tables to export' list
3. Click the 'Advanced Options...' button (top right)
4. Search for the option 'Other/column-statistics'
5. Set the value to 0
6. Click the 'Return' button (top right)

Now it should work. Unfortunately, you'll have to do that every time you start MySql Workbench.

I too had the same problem.. I am able to resolve this Issue by disabling the column-statistics in the advanced options of the MySQL Workbench Data Export.

1: Click on the advanced options:
[![enter image description here][1]][1]


2: In the other section for the column-statistics remove TRUE and set it to 0 to disable it.
[![enter image description here][2]][2]


[1]:

[2]:

Now Return and Export the Data.
Thank You

I had the same problem and I solved it like this:

edit the workbench preferences:
Edit -> Preferences -> Administration

in the property "Path to mysqldump Tool" place the path of your mysqldump.exe
It is usually found in "C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqldump.exe"

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.

Bug still in Workbench 8.0.16.

Fix:

You can edit wb_admin_export.py under modules in the workbench program directory. Search for "skip_column_statistics = True" (you will find a conditional, don't worry), comment that line and add a line "skip_column_statistics = True" (without a conditional).

The required parameter will now be always added.

Go to `C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules` and open this file `wb_admin_export.py` and uncomment "`--column-statistics=0`" then Restart the workbench

I found this condition in `wb_admin_export.py` instead of a commented `--column-statistics=0`. you can remove the `else False` condition, or change it to `else True`.

skip_column_statistics = True if get_mysqldump_version() > Version(8,
0, 2) and self.owner.ctrl_be.target_version < Version(8, 0, 0) else
True

in version 8, I modified "wb_admin_export.py" and restart workbench. works for me
```
def start(self):
.
.
.
title = "Dumping " + schema
title += " (%s)" % table
# description, object_count, pipe_factory, extra_args, objects
args = []
args.append('--column-statistics=0')
```
```
class ViewsRoutinesEventsDumpData(DumpThread.TaskData):
def __init__(self, schema, views, args, make_pipe):
title = "Dumping " + schema + " views and/or routines and/or events"
if not views:
extra_args = ["--no-create-info"]
else:
extra_args = []
DumpThread.TaskData.__init__(self,title, len(views), ["--skip-triggers", " --no-data" ," --no-create-db", "--column-statistics=0"] + extra_args + args, [schema] + views, None, make_pipe)```