title: How import xml files with mysql LOAD XML LOCAL INFILE
body: <p>I have a xml file like this:</p>
  
  <blockquote>
    <p>test.xml</p>
  </blockquote>
  
  <pre><code>&lt;?xml version="1.0" encoding="utf-8" ?&gt;
  &lt;plugin name="tree"&gt;
      &lt;title&gt;Test&lt;/title&gt;
      &lt;description&gt;some description&lt;/description&gt;
      &lt;files&gt;
          &lt;file&gt;test.tmp&lt;/file&gt;
      &lt;/files&gt;
      &lt;install&gt;&lt;![CDATA[
          global $test;
      ]]&gt;&lt;/install&gt;
      &lt;hooks&gt;
          &lt;hook name="hookname"&gt;&lt;![CDATA[
              global $local;
          ]]&gt;&lt;/hook&gt;
      &lt;/hooks&gt;
  
      &lt;phrases&gt;
          &lt;phrase key="category"&gt;&lt;![CDATA[Show categories]]&gt;&lt;/phrase&gt;
      &lt;/phrases&gt;
  &lt;/plugin&gt;
  </code></pre>
  
  <p>and i like to import it into a MySQL Table like 'mytable'</p>
  
  <pre><code>CREATE TABLE mytable (plugin varchar(255),title varchar(255),description varchar(255), file varchar(255),install varchar(255),hook varchar(255),phrase varchar(255));
  </code></pre>
  
  <p>I used below command</p>
  
  <pre><code>LOAD XML LOCAL INFILE 'test.xml' 
  INTO TABLE mytable(plugin,title,description,file,install,hook,phrase);
  </code></pre>
  
  <p>it runs successfully but with 0 rows!</p>
  
  <blockquote>
    <p>The query has been successfully implemented, 0 rows have been
    affected.</p>
  </blockquote>
  
  <p>Thank you</p>