Bug #36917 mysqldump --xml don't dump field comment ?

Submitted: 23 May 2008 14:44 Modified: 5 May 2009 17:46
Reporter: Mathieu Virbel Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: mysqldump Command-line Client Severity:S3 (Non-critical)
Version:Ver 10.11 Distrib 5.0.51a, 4.1, 5.0, 5.1, 6.0 BK OS:Linux (Ubuntu Hardy)
Assigned to: CPU Architecture:Any

[23 May 2008 14:44] Mathieu Virbel
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 :)
[23 May 2008 16:20] Sveta Smirnova
Thank you for the report.

Verified as described.
[5 May 2009 17:46] Jim Winstead
This is a duplicate of Bug #13618.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.055 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.