title: Using XML and XSD to create a populated database
body: <p>I'm not sure if this is possible, but figured I'd ask and see if I can get any info.</p>
  
  <p>As the title suggests, I have an XML file with thousands of lines. I also have its associated XSD schema file.</p>
  
  <p>I was wondering, is it possible for me to convert this data into a MySQL database without manually specifying the XPath stuff?</p>
  
  <p>For example, is it possible for a Java or Python or whatever program to analyse the XML structure, based on the XSD, extract the table columns, and populate it with data?</p>
  
  <p>I tried using PHPMyAdmin to import my XML file, but it didn't work and said there was a problem, which I think was related to the fact that it couldn't create the columns. As far as I know, it can handle CSV files better, so that's another option for a 2 stage conversion.</p>
  
  <p>Thanks.</p>