Using XML and XSD to create a populated database

[avengr]

I'm not sure if this is possible but figured I'd ask and see if I can get any info.As the title suggests, I have an XML file with thousands of lines. I also have its associated XSD schema file.I was wondering, is it possible for me to convert this data into a mysql database, without manually specifying the XPATH stuff?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?I tried using phpmyadmin to import my XML file,but it didnt work, saying there was a problem, which I think was related to the fact that it couldnt create the columns, but as far as I know, it can handle CSV files better, so thats another option for a 2 stage conversion.Thanks.