title: How to restore a mysql xml database file from mysql command line?
body: <p>I am running Windows XP, using the MySQL shell and PowerShell (MySQL 5.5), using XAMPP for Windows.</p>
  
  <p>I have an XML file which I've placed in E:\xampp\mysql\bin for convenience.  I can run .\mysqldump.exe and .\mysql.exe but don't seem to be able to find the correct syntax for the type of XML file I'm using.</p>
  
  <p>The XML file is laid out like this:</p>
  
  <pre><code>&lt;mysqldump&gt;
  &lt;database name="export"&gt;
  &lt;table_structure name="export_rental_2006_property"&gt;
  &lt;field Field="id" Type="bigint(20)" Null="NO" Key="" Default="" Extra=""/&gt;
  &lt;field Field="name" Type="varchar(255)" Null="NO" Key="" Default="" Extra=""/&gt;
  </code></pre>
  
  <p>...and so on, with "table_data" tags, "row" tags, and "field" tags with name= attributes etc.</p>
  
  <p>Just to let you know, I have no way of changing the export format - this is what I have to import.  I've looked around and nothing I've tried from various tutorials and the MySQL website seemed to have worked.  Maybe I'm getting the procedure wrong.</p>
  
  <p>If anybody has experience with this, help would be very appreciated.</p>
  
  <p>Thanks</p>