Bug #89825 8.0 mysqldump cannot dump 5.x by default
Submitted: 27 Feb 2018 13:07 Modified: 27 Feb 2018 13:21
Reporter: Frederic Descamps Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: mysqldump Command-line Client Severity:S3 (Non-critical)
Version:8.0.4, 8.0.16 OS:Linux
Assigned to: CPU Architecture:Any

[27 Feb 2018 13:07] Frederic Descamps
Description:
Trying to dump a database from 5.5 using mysqldump of 8.0.4, it fails because it tries to check for histograms. However if I check in the documentation, column statistics should be disabled by default (https://dev.mysql.com/doc/refman/8.0/en/mysqldump.html#option_mysqldump_column-statistics)

How to repeat:
mysqldump -h relational.fit.cvut.cz --column-statistics -u guest -prelational imdb_ijs actors > actors.sql
mysqldump: [Warning] Using a password on the command line interface can be insecure.
mysqldump: Couldn't execute 'SELECT COLUMN_NAME,                       JSON_EXTRACT(HISTOGRAM, '$."number-of-buckets-specified"')                FROM information_schema.COLUMN_STATISTICS                WHERE SCHEMA_NAME = 'imdb_ijs' AND TABLE_NAME = 'actors';': Unknown table 'COLUMN_STATISTICS' in information_schema (1109)

workaround: disable column-statistics using --column-statistics=0

[root@mysql2 datas]# mysqldump -h relational.fit.cvut.cz --column-statistics=0 -u guest -prelational imdb_ijs actors > actors.sql
mysqldump: [Warning] Using a password on the command line interface can be insecure.

Suggested fix:
Update the documentation according or disable column-statistics by default
[27 Feb 2018 13:21] MySQL Verification Team
Hello Frederic,

Thank you for the report!

Thanks,
Umesh
[30 May 2018 11:47] Den ____
seems same issue in 8.0.11
[31 May 2018 10:47] Michael Law
This is still an issue for me as well.
[1 Jul 2018 17:32] Reinaldo Rei
I have the same issue
[31 Jul 2018 12:07] Flo Bayer
Same here with 8.0.12
[23 Aug 2018 2:34] Pierre Caron
Same problem here where I tried to export the date from MySql Workbench.
Is there a workaround in Workbench?
[23 Aug 2018 15:17] LEANDRO lcferreira
Workbench:

Select menu Edit->preferences->administration. Add mysql information:

path to mysqldump tool: /usr/bin/mysqldump
path to mysql tool: /usr/bin/mysql

I use ubuntu 18.04
[24 Oct 2018 14:34] Frederic MEYER
Sadly enough, still an issue with 8.0.13
[24 Oct 2018 14:46] Frederic MEYER
workaround in 8.0.13

Attachment: Screenshot 2018-10-24 at 16.44.48.png (image/png, text), 236.71 KiB.

[26 Jun 2019 7:51] MySQL Verification Team
Bug #95992 marked as duplicate of this one