Description:
XML dump don't report comment field, but a simple SQL dump do. Is it normal ?
XML DUMP :
----------
<mysqldump xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<database name="pec">
<table_structure name="conf_category">
<field Field="id" Type="int(10) unsigned" Null="NO" Key="PRI" Extra="auto_increment" />
<field Field="name" Type="varchar(20)" Null="YES" Key="" Extra="" />
<field Field="description" Type="varchar(100)" Null="YES" Key="" Extra="" />
<key Table="conf_category" Non_unique="0" Key_name="PRIMARY" Seq_in_index="1" Column_name="id" Collation="A" Cardinality="3" Null="" Index_type="BTREE" Comment="" />
<options Name="conf_category" Engine="MyISAM" Version="10" Row_format="Dynamic" Rows="3" Avg_row_length="45" Data_length="136" Max_data_length="281474976710655" Index_length="2048" Data_free="0" Auto_increment="4" Create_time="2008-05-23 13:47:49" Update_time="2008-05-23 13:47:49" Collation="utf8_unicode_ci" Create_options="" Comment="" />
</table_structure>
</database>
</mysqldump>
SQL DUMP :
----------
CREATE TABLE `conf_category` (
`id` int(10) unsigned NOT NULL auto_increment COMMENT 'Identifiant de la catégorie',
`name` varchar(20) collate utf8_unicode_ci default NULL COMMENT 'Nom de la catégorie',
`description` varchar(100) collate utf8_unicode_ci default NULL COMMENT 'Description de la catégorie',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
How to repeat:
Create a field in a table with a comment, and use mysqldump --xml
Suggested fix:
Add comment in "field" tag :)
