Edit File: loadxml2.dat
<?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>