title: Import CSV or XML to MySQL
body: <p>I have two huge databases in both formats CSV &amp; XML, and I want to import to MySQL the databases.</p>
  
  <p>I tried to used : LOAD DATA INFILE, but I receive this error message :
  ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1</p>
  
  <p>MySQL Version : 5.1.56-log</p>
  
  <p>I tried without any success to use PHP to convert XML to array then Insert line by line.</p>
  
  <p>EDIT :</p>
  
  <p>I used this query as root to import XML to MySQL :</p>
  
  <p>LOAD XML LOCAL FILE '/home/floupie/public_html/All.xml' INTO TABLE <code>k_logs</code>;</p>