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 Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: mysqldump Command-line Client Severity:S4 (Feature request)
Version:5.7, 8.0 OS:Any
Assigned to: CPU Architecture:Any
Tags: format, mysqldump, row

[6 Jul 2023 8:39] Yoni Sade
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.

[6 Jul 2023 9:28] MySQL Verification Team
Hello Yoni Sade,

Thank you for the reasonable feature request!