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 Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: mysqldump Command-line Client Severity:S2 (Serious)
Version:5.7 OS:Any
Assigned to: 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