Quelle  loadxml2.dat  Sprache: unbekannt

<?xml version="1.0"?>
<mysqldump xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<database name="test_of_xml_import">
 <table_structure name="t1">
  <field Field="id" Type="int(11)" Null="NO" Key="PRI" Extra="" />
  <field Field="text" Type="text" Null="YES" Key="" Extra="" />
  <key Table="t1" Non_unique="0" Key_name="PRIMARY" Seq_in_index="1" Column_name="id" Collation="A" Cardinality="1" Null="" Index_type="BTREE" Comment="" Index_Comment="" />
  <options Name="t1" Engine="MyISAM" Version="10" Row_format="Dynamic" Rows="1" Avg_row_length="32" Data_length="32" Max_data_length="281474976710655" Index_length="2048" Data_free="0" Create_time="2009-06-18 10:02:37" Update_time="2009-06-18 10:02:43" Collation="latin1_swedish_ci" Create_options="" Comment="" />
 </table_structure>
 <table_data name="t1">
 <row>
  <field name="id">1</field>
  <field name="text">line1
line2
line3</field>
 </row>
 </table_data>
</database>
</mysqldump>