Symptom

When attempting to take a MySQL backup within Workbench, the following error message is given:

"11:32:45 Dumping curatordb (all tables)
Running: mysqldump.exe --defaults-file="c:\users\pm-ipv\appdata\local\temp\4\tmppzvk0q.cnf" --user=root --host=localhost --protocol=tcp --port=3306 --default-character-set=utf8 --single-transaction=TRUE --routines --events "curatordb"
mysqldump: Couldn't execute 'SELECT COLUMN_NAME, JSON_EXTRACT(HISTOGRAM, '$."number-of-buckets-specified"') FROM information_schema.COLUMN_STATISTICS WHERE SCHEMA_NAME = 'curatordb' AND TABLE_NAME = 'audio';': Unknown table 'column_statistics' in information_schema (1109)

Operation failed with exitcode 2"

Resolution. 

The issue arises with MySQL Dump version 8 and occurs due to the column-statistics variable being set to True by default. To resolve this issue, you will need to go to 'Advanced Options' in the 'Data Export' section of workbench. Then change 'column-statistics' to '0' as illustrated below: