mysqldump --xml --compact dbname > out.xml

##</code><code>##

my $db=qq(classicmodels);
my $xml= qx(mysqldump --xml --compact $db);

##</code><code>##


<?xml version="1.0"?>
<mysqldump xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<database name="classicmodels">
	<table_structure name="customers">
		<field Field="customerNumber" Type="int(11)" Null="NO" Key="PRI" Extra="" Comment="" />
		<field Field="customerName" Type="varchar(50)" Null="NO" Key="" Extra="" Comment="" />
		<field Field="contactLastName" Type="varchar(50)" Null="NO" Key="" Extra="" Comment="" />
		<field Field="contactFirstName" Type="varchar(50)" Null="NO" Key="" Extra="" Comment="" />
		<field Field="phone" Type="varchar(50)" Null="NO" Key="" Extra="" Comment="" />
		<field Field="addressLine1" Type="varchar(50)" Null="NO" Key="" Extra="" Comment="" />
		<field Field="addressLine2" Type="varchar(50)" Null="YES" Key="" Extra="" Comment="" />
		<field Field="city" Type="varchar(50)" Null="NO" Key="" Extra="" Comment="" />
		<field Field="state" Type="varchar(50)" Null="YES" Key="" Extra="" Comment="" />
		<field Field="postalCode" Type="varchar(15)" Null="YES" Key="" Extra="" Comment="" />
		<field Field="country" Type="varchar(50)" Null="NO" Key="" Extra="" Comment="" />
		<field Field="salesRepEmployeeNumber" Type="int(11)" Null="YES" Key="" Extra="" Comment="" />
		<field Field="creditLimit" Type="double" Null="YES" Key="" Extra="" Comment="" />
		<key Table="customers" Non_unique="0" Key_name="PRIMARY" Seq_in_index="1" Column_name="customerNumber" Collation="A" Cardinality="122" Null="" Index_type="BTREE" Comment="" Index_comment="" />
		<options Name="customers" Engine="MyISAM" Version="10" Row_format="Dynamic" Rows="122" Avg_row_length="114" Data_length="13992" Max_data_length="281474976710655" Index_length="4096" Data_free="0" Create_time="2012-11-09 09:53:36" Update_time="2012-11-09 09:53:36" Collation="latin1_swedish_ci" Create_options="" Comment="" />
	</table_structure>
	<table_data name="customers">
	<row>
		<field name="customerNumber">103</field>
		<field name="customerName">Atelier graphique</field>
		<field name="contactLastName">Schmitt</field>
		<field name="contactFirstName">Carine </field>
		<field name="phone">40.32.2555</field>
		<field name="addressLine1">54, rue Royale</field>
		<field name="addressLine2" xsi:nil="true" />
		<field name="city">Nantes</field>
		<field name="state" xsi:nil="true" />
		<field name="postalCode">44000</field>
		<field name="country">France</field>
		<field name="salesRepEmployeeNumber">1370</field>
		<field name="creditLimit">21000</field>
	</row>
<!-- Skipped the next 20.000 lines... -->