Bug #88879 Make mysqldump --all-tablespaces to work with InnoDB general tablespaces as well

• Submitted: 12 Dec 2017 15:34
• Modified: 15 Dec 2017 8:06
• Reporter: Shahriyar Rzayev
• Status: Duplicate
• Category: MySQL Server: mysqldump Command-line Client
• Severity: S2 (Serious)
• Version: 5.7
• OS: Any
• CPU Architecture: Any

[12 Dec 2017 15:34] Shahriyar Rzayev

Description:
According to the DOC:
https://dev.mysql.com/doc/refman/5.7/en/mysqldump.html#mysqldump-ddl-options

--all-tablespaces, -Y

Adds to a table dump all SQL statements needed to create any tablespaces used by an NDB table. This information is not otherwise included in the output from mysqldump. This option is currently relevant only to NDB Cluster tables, which are not supported in MySQL 5.7. 

Same for 8.0:
https://dev.mysql.com/doc/refman/8.0/en/mysqldump.html#mysqldump-ddl-options

--all-tablespaces, -Y

Adds to a table dump all SQL statements needed to create any tablespaces used by an NDB table. This information is not otherwise included in the output from mysqldump. This option is currently relevant only to MySQL Cluster tables, which are not supported in MySQL 8.0. 

As with MySQL 5.7 we have General Tablespaces with InnoDB also, which are quite often used and I am currently looking for an option to store create statements(creation) of those general tablespaces in dump for my further tests(for now I am creating and running alters with each test start).

As shown this feature is missing from mysqldump according to the DOC.

How to repeat:
See description

[15 Dec 2017 8:06] MySQL Verification Team

Hello Shahriyar,

Thank you for the feature request!
This is duplicate of Sugiyama-San's Bug #78916.

Thanks,
Umesh