just for reference beginning of this XML file is
<?xml version="1.0"?>
<mysqldump xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<database name="wikidb">
<table_structure name="mw_archive">
<field Field="ar_id" Type="int(10) unsigned" Null="NO" Key="PRI" Extra="auto_increment" Comment="" />
<field Field="ar_namespace" Type="int(11)" Null="NO" Key="MUL" Default="0" Extra="" Comment="" />
<field Field="ar_title" Type="varbinary(255)" Null="NO" Key="" Default="" Extra="" Comment="" />
<field Field="ar_text" Type="mediumblob" Null="NO" Key="" Extra="" Comment="" />
<field Field="ar_comment" Type="tinyblob" Null="NO" Key="" Extra="" Comment="" />
<field Field="ar_user" Type="int(10) unsigned" Null="NO" Key="" Default="0" Extra="" Comment="" />
<field Field="ar_user_text" Type="varbinary(255)" Null="NO" Key="MUL" Extra="" Comment="" />
<field Field="ar_timestamp" Type="binary(14)" Null="NO" Key="" Default="" Extra="" Comment="" />
<field Field="ar_minor_edit" Type="tinyint(4)" Null="NO" Key="" Default="0" Extra="" Comment="" />
<field Field="ar_flags" Type="tinyblob" Null="NO" Key="" Extra="" Comment="" />
<field Field="ar_rev_id" Type="int(10) unsigned" Null="YES" Key="MUL" Extra="" Comment="" />
<field Field="ar_text_id" Type="int(10) unsigned" Null="YES" Key="" Extra="" Comment="" />
<field Field="ar_deleted" Type="tinyint(3) unsigned" Null="NO" Key="" Default="0" Extra="" Comment="" />
<field Field="ar_len" Type="int(10) unsigned" Null="YES" Key="" Extra="" Comment="" />
<field Field="ar_page_id" Type="int(10) unsigned" Null="YES" Key="" Extra="" Comment="" />
<field Field="ar_parent_id" Type="int(10) unsigned" Null="YES" Key="" Extra="" Comment="" />
<field Field="ar_sha1" Type="varbinary(32)" Null="NO" Key="" Default="" Extra="" Comment="" />
<field Field="ar_content_format" Type="varbinary(64)" Null="YES" Key="" Extra="" Comment="" />
<field Field="ar_content_model" Type="varbinary(32)" Null="YES" Key="" Extra="" Comment="" />
<key Table="mw_archive" Non_unique="0" Key_name="PRIMARY" Seq_in_index="1" Column_name="ar_id" Collation="A" Cardinality="0" Null="" Index_type="BTREE" Comment="" Index_comment="" />
<key Table="mw_archive" Non_unique="1" Key_name="name_title_timestamp" Seq_in_index="1" Column_name="ar_namespace" Collation="A" Cardinality="0" Null="" Index_type="BTREE" Comment="" Index_comment="" />
<key Table="mw_archive" Non_unique="1" Key_name="name_title_timestamp" Seq_in_index="2" Column_name="ar_title" Collation="A" Cardinality="0" Null="" Index_type="BTREE" Comment="" Index_comment="" />
<key Table="mw_archive" Non_unique="1" Key_name="name_title_timestamp" Seq_in_index="3" Column_name="ar_timestamp" Collation="A" Cardinality="0" Null="" Index_type="BTREE" Comment="" Index_comment="" />
<key Table="mw_archive" Non_unique="1" Key_name="usertext_timestamp" Seq_in_index="1" Column_name="ar_user_text" Collation="A" Cardinality="0" Null="" Index_type="BTREE" Comment="" Index_comment="" />
<key Table="mw_archive" Non_unique="1" Key_name="usertext_timestamp" Seq_in_index="2" Column_name="ar_timestamp" Collation="A" Cardinality="0" Null="" Index_type="BTREE" Comment="" Index_comment="" />
<key Table="mw_archive" Non_unique="1" Key_name="ar_revid" Seq_in_index="1" Column_name="ar_rev_id" Collation="A" Cardinality="0" Null="YES" Index_type="BTREE" Comment="" Index_comment="" />
<options Name="mw_archive" Engine="InnoDB" Version="10" Row_format="Compact" Rows="0" Avg_row_length="0" Data_length="16384" Max_data_length="0" Index_length="49152" Data_free="5242880" Auto_increment="1" Create_time="2014-09-13 02:23:19" Collation="binary" Create_options="" Comment="" />
</table_structure>
<table_data name="mw_archive">
</table_data>
<table_structure name="mw_category">
<field Field="cat_id" Type="int(10) unsigned" Null="NO" Key="PRI" Extra="auto_increment" Comment="" />
<field Field="cat_title" Type="varbinary(255)" Null="NO" Key="UNI" Extra="" Comment="" />
<field Field="cat_pages" Type="int(11)" Null="NO" Key="MUL" Default="0" Extra="" Comment="" />
<field Field="cat_subcats" Type="int(11)" Null="NO" Key="" Default="0" Extra="" Comment="" />
<field Field="cat_files" Type="int(11)" Null="NO" Key="" Default="0" Extra="" Comment="" />
<key Table="mw_category" Non_unique="0" Key_name="PRIMARY" Seq_in_index="1" Column_name="cat_id" Collation="A" Cardinality="40" Null="" Index_type="BTREE" Comment="" Index_comment="" />
<key Table="mw_category" Non_unique="0" Key_name="cat_title" Seq_in_index="1" Column_name="cat_title" Collation="A" Cardinality="40" Null="" Index_type="BTREE" Comment="" Index_comment="" />
<key Table="mw_category" Non_unique="1" Key_name="cat_pages" Seq_in_index="1" Column_name="cat_pages" Collation="A" Cardinality="40" Null="" Index_type="BTREE" Comment="" Index_comment="" />
<options Name="mw_category" Engine="InnoDB" Version="10" Row_format="Compact" Rows="40" Avg_row_length="409" Data_length="16384" Max_data_length="0" Index_length="32768" Data_free="5242880" Auto_increment="41" Create_time="2014-09-13 02:23:19" Collation="binary" Create_options="" Comment="" />
</table_structure>
<table_data name="mw_category">
<row>
<field name="cat_id">1</field>
<field name="cat_title">Debian</field>
<field name="cat_pages">18</field>
<field name="cat_subcats">0</field>
<field name="cat_files">0</field>