Bug #76735 mysqldump dumps sys_schema

• Submitted: 17 Apr 2015 12:40
• Modified: 22 Apr 2015 13:07
• Reporter: Ståle Deraas
• Status: Closed
• Category: MySQL Server: mysqldump Command-line Client
• Severity: S3 (Non-critical)
• Version: 5.7.7
• OS: Any
• CPU Architecture: Any

[17 Apr 2015 12:40] Ståle Deraas

Description:
mysqldump seems to dump information about sys_schema after the push WL#8159. 

How to repeat:
mysqldump [...] --all-databases

Then look in the dump for the "sys" database

Suggested fix:
Handle as performance schema

[22 Apr 2015 13:07] Paul DuBois

Noted in 5.7.8, 5.8.0 changelogs.

mysqldump no longer dumps the sys schema by default. It is still
possible to dump it by naming it explicitly on the command line (for
example, mysqldump --databases sys).