Bug #1530 "mysqldump -u root -d --xml" produces no real output
Submitted: 11 Oct 2003 1:30 Modified: 14 Oct 2003 7:21
Reporter: Ralf Hauser Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: mysqldump Command-line Client Severity:S4 (Feature request)
Version:9.08 OS:Linux (linux (Suse)/win2k)
Assigned to: Ramil Kalimullin CPU Architecture:Any

[11 Oct 2003 1:30] Ralf Hauser 
Description:
While without the "--xml" the full structure is dumped as sql statements, with "--xml", all the table names and field information is lost!

I only get:

<?xml version="1.0"?>
<mysqldump>
<database name="dbname">
</database>
</mysqldump>

but not all the other structure information I would like to have!

How to repeat:
mysqldump -u root -d --xml

Suggested fix:
provide all structure information in xml format
[12 Oct 2003 19:40] MySQL Verification Team 
Thank you for the bug report I was able to repeat.
[14 Oct 2003 2:30] Ramil Kalimullin 
Hi!

Could you describe the XML format of table structure you need?
Please send us a short example.

Regards,
Ramil Kalimullin.
[14 Oct 2003 2:38] Ralf Hauser 
Basically, you can take what you get and convert it into xml,
so
CREATE TABLE tbl_user (
  user_id int(10) unsigned NOT NULL auto_increment,
  login char(100) NOT NULL default '',
  password char(255) NOT NULL default '',
  forename char(100) NOT NULL default '',
  lastname char(100) NOT NULL default '',
  titel smallint(6) default NULL,
  cur char(3) NOT NULL default '',
  pay_id int(10) unsigned NOT NULL default '0',
  lang_id smallint(5) unsigned NOT NULL default '0',
  logo_url char(255) NOT NULL default '',
  last_login datetime NOT NULL default '0000-00-00 00:00:00',
...

how about 
<DBMS_SERVER_NAME>
  <DB_NAME1>
    <TBL_NAME1>
      <FIELD_NAME1 autoincrement="true" type="char" precision="200" 
        nullable="true" default="abc" signed="true" ... />
      <FIELD_NAME2 autoincrement="false" type="int" precision="20" unsigned="true" ... />
      ...
    </TBL_NAME1>
    <TBL_NAME2>
    ...
  </DB_NAME1>
  <DB_NAME2>
  ...
  </DB_NAME_N>
<DBMS_SERVER_NAME>
[14 Oct 2003 3:20] Ramil Kalimullin 
Thank you for your suggestion.
Added to our todo list.
[13 Jan 2004 23:13] Ralf Hauser 
once this is fixed, it would be used for http://bugs.mysql.com/bug.php?id=1307