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: | |
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
[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