MySQL Bugs: #90665: Data Export Fails to display internal Schemas

Bug #90665	Data Export Fails to display internal Schemas
Submitted:	27 Apr 2018 10:51	Modified:	30 May 2018 16:57
Reporter:	IGG t	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: Administration	Severity:	S3 (Non-critical)
Version:	8.011	OS:	Windows (10)
Assigned to:		CPU Architecture:	Any
Tags:	dump, MySQL

Description:
When in the Data Export section, and going to Advanced options, there is the option to select "$internal$show-internal-schemas - Show internal MySQL schemas (mysql, information_schema, performance_schema) in the export list."

However when selecting this, the export list still doesn't show these internal schemas.

I have tried this with MySQL 5.5, 5.7, and 8.0 databases.

How to repeat:
Go to Data Export Section

Click on Advanced options...

Ensure that the option for $internal$show-internal-schemas - Show internal MySQL schemas (mysql, information_schema, performance_schema) in the export list" is ticked

click <Return

Click Refresh

and the above mentioned schema are not displayed. The only ones displayed are the user created Schema, and the SYS schema.

Suggested fix:
display the internal schemas when the option is selected

option is selected

Attachment: Screenshot_2.png (image/png, text), 4.80 KiB.

schemas still not displayed

Attachment: Screenshot_3.png (image/png, text), 2.90 KiB.

Hello IGG,

Thank you for the bug report.
Verified this behavior on MySQL Workbench in 8.0.11 version.

Thanks,
Chiranjeevi.

Posted by developer:
 
commit id: d8ddc1d7aa340318c497baa79dc344525ff35037

Posted by developer:
 
Fixed as of the upcoming MySQL Workbench 8.0.12 release, and here's the changelog entry:

The advanced option, $internal$show-internal-schemas - Show internal MySQL
schemas (mysql, information_schema, performance_schema) in the export
list, within the Administration – Data Export tab did not expose
internal schemas as expected.

Thank you for the bug report.