Fair enough,
but I have one suggestion: that xml from "Export grid data" could be more compatibile with MySQLDump:
- currently there is no root node with declaration of namespace "xsi", which is used to mark "null" fields,
- there is no "database" node, which is generated by mysqldump,
- there is no "table_structure" node, which is also generated by mysqldump.
The two last suggestions could be optional, and we can discuss if there is such need at all, but without proper declaration of namespace, current XML format is simply invalid.
And last but not least: ability to export data from more than one table to such XML file would be a cherry on the cake :)
Are there any chances to add above functionalities to my favorite MySQL tool
PS: sample mysqldump file, for one table
<?xml version="1.0"?>
<mysqldump xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<database name="test">
<table_structure name="categories">
<field Field="id" Type="int(11)" Null="NO" Key="PRI" Extra="auto_increment" Comment="" />
<field Field="id_rand" Type="int(11)" Null="NO" Key="PRI" Extra="" Comment="" />
...
<key Table="categories" Non_unique="0" Key_name="PRIMARY" Seq_in_index="1" Column_name="id" Collation="A" Cardinality="16" Null="" Index_type="BTREE" Comment="" Index_comment="" />
<key Table="categories" Non_unique="0" Key_name="PRIMARY" Seq_in_index="2" Column_name="id_rand" Collation="A" Cardinality="16" Null="" Index_type="BTREE" Comment="" Index_comment="" />
...
<options Name="categories" Engine="InnoDB" Version="10" Row_format="Compact" Rows="16" Avg_row_length="1024" Data_length="16384" Max_data_length="0" Index_length="65536" Data_free="0" Auto_increment="17" Create_time="2014-02-21 11:42:49" Collation="utf8_polish_ci" Create_options="" Comment="" />
</table_structure>
<table_data name="categories">
<row>
<field name="id">1</field>
<field name="last_change">2014-02-08 23:03:49</field>
...
</row>
<row>
...
</row>
</table_data>
</database>
</mysqldump>