title: Easiest way t convert a large XML file to MySQL
body: <p>I have a 63MB XML file which is basically a list of chess players, it looks like this:</p>
  
  <pre><code>&lt;playerslist&gt;
     &lt;player&gt;
         &lt;fideid&gt;&lt;/fideid&gt;
         &lt;name&gt;&lt;/name&gt;
         &lt;country&gt;&lt;/country&gt;
         &lt;sex&gt;&lt;/sex&gt;
         &lt;title&gt;&lt;/title&gt;
         &lt;rating&gt;&lt;/rating&gt;
     &lt;/player&gt;
     &lt;player&gt;
        ...
     &lt;/player&gt;
  &lt;/playerslist&gt;
  </code></pre>
  
  <p>I want to use this data on a website and be able to do searches on it, so having it as a table in a mySQL database would be the most convenient thing for me. <br>
  So, what would be the easiest way to convert this XML file to a mySQL database?</p>