MySQL Forums
Forum List  »  Connector/Node.js

Importing XML/XSD data
Posted by: Alex Bertmann
Date: May 18, 2011 02:43PM

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

Options: ReplyQuote


Subject
Written By
Posted
Importing XML/XSD data
May 18, 2011 02:43PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.