Bug #111676 Add mysqldump option to include ROW_FORMAT in CREATE TABLE statsments

• Submitted: 6 Jul 2023 8:39
• Modified: 6 Jul 2023 9:28
• Reporter: Yoni Sade
• Status: Verified
• Category: MySQL Server: mysqldump Command-line Client
• Severity: S4 (Feature request)
• Version: 5.7, 8.0
• OS: Any
• CPU Architecture: Any
• Tags: format, mysqldump, row

[6 Jul 2023 8:39] Yoni Sade

Description:
Currently, ROW_FORMAT option is not included in CREATE TABLE DDL generated by mysqldump which creates them with the default row format on a target server.

How to repeat:
Run mysqldump v5.7.42 / v8.0.33 to dump table(s) and see ROW_FORMAT is not part of the CREATE TABLE DDL in the dump file

Suggested fix:
Please add to both new versions of mysqldump a command line option flag for including the ROW_FORMAT=[XXXXXXXX] in CREATE TABLE statements in dump file so tables would be created on the target exactly the same as in source.

--include-row-format

[6 Jul 2023 9:28] MySQL Verification Team

Hello Yoni Sade,

Thank you for the reasonable feature request!

regards,
Umesh