Hi folks
while I'm not a complete newb at mysql I completely fail at this one thing. DrugBank is an openly available database for which mirrors are available at
http://www.drugbank.ca/downloads. Specifically, they provide a rather large XML file (roughly 90 MB) along with a schema, available at
http://www.drugbank.ca/docs/drugbank.xsd
Now, I've been trying for the past hours to import this data into a new database on my Mac OSX 10.6 with MySQL 5.5. I am not interested in a single table but the whole database. I've googled for load table commands, tried middleware such as Navicat (lite), MySQL Workbench, and - I admit - even Filemaker. I tried creating tables from the XSD file with xmldbms but it crashes because of the Manifest being malformed or something.
I'm really at a loss here. I see the data in the xml, I see the data structure in the xsd, and I'm pretty sure this must be a standard problem. So, can anyone please point me in the general direction?
Your help is very much appreciated!
Alex