Bug #97520 Workbench 8.0.18 cannot export from MySQL 5.7 database
Submitted: 6 Nov 2019 18:20 Modified: 18 Nov 2019 18:22
Reporter: Uriel Bertoche Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: Administration Severity:S3 (Non-critical)
Version:8.0.14, 8.0.18 OS:Any
Assigned to: CPU Architecture:Any

[6 Nov 2019 18:20] Uriel Bertoche
Description:
Same problem since 8.0.14, after a fix there was an option to disable data export using COLUMN_STATISTICS, but ever since version 8.0.14 the option is gone and it's no longer possible to use the "Server > Data Export" feature on MySQL Workbench on 5.7 MySQL or MariaDB servers.

How to repeat:
Try to use the "Server > Data Export" tool on a MySQL Server 5.x or MariaDB.

Suggested fix:
Bring back the advanced option to disable column-statistics
[7 Nov 2019 12:07] MySQL Verification Team
Hello Uriel Bertoche,

Thank you for the report and test case.
Observed this with WB 8.0.18 on Win10.

regards,
Umesh
[8 Nov 2019 8:01] Mike Lischke
The option to disable column statistics on data export is here.

Attachment: column-statistics.png (image/png, text), 329.19 KiB.

[8 Nov 2019 8:02] Mike Lischke
Uriel, can you explain why this option is not sufficient for you?
[8 Nov 2019 12:31] Uriel Bertoche
Absolutely. Because this option is not available for me on 8.0.18, nor in any version after 8.0.14. To use this I had to revert back to 8.0.13.
[8 Nov 2019 12:32] Uriel Bertoche
No option regarding column-statistics available on 8.0.18

Attachment: DeepinScreenshot_select-area_20191108093005.png (image/png, text), 59.73 KiB.

[18 Nov 2019 11:31] Miguel Tadeu Mota
Posted by developer:
 
commit id: 78439a99c0ac6219c93009cdccc55dd5d378c7b3
[18 Nov 2019 18:22] Christine Cole
Posted by developer:
 
Fixed as of the upcoming MySQL Workbench 8.0.19 release, and here's the changelog entry:

When attempting to export MySQL 5.7 data using MySQL Workbench 8.0, the
server returned an error indicating that
INFORMATION_SCHEMA.COLUMN_STATISTICS was an unknown table. Consistent
parameter use with mysqldump now skips the table as expected.

Thank you for the bug report.
[21 Jan 2020 19:38] Michael ONeil
Version 8.0.19 the column-statistics option is still not available.
No current workaround available.
[3 May 2020 16:07] Juanan Pereira
Well, there seems to be a workaround: 
https://serverfault.com/a/1015459/310606