Create Schema and repeatable import of XML

2015-03-09 Thread Sayth Renshaw
Hi Hoping someone can help me work some information or direction to a good resource for using XML with Mysql. Specifically I have a complex XML file, I would like to create a schema in MYSQL based on it (I have XSD as well) and be able to upload new xml data into the database as it's released

Re: Xml data import

2014-12-12 Thread Sayth Renshaw
Message - From: Sayth Renshaw flebber.c...@gmail.com Subject: Xml data import I have an xml data feed with xsd, it's complex in elements not size. Wray are the best way to get data into mysql, do I have to hack with xquery? That's going to depend on the complexity of your XML and how

Re: Xml data import

2014-12-12 Thread Sayth Renshaw
And does that then lead you to use Fabric? http://de.slideshare.net/mobile/nixnutz/mysql-57-fabric-high-availability-and-sharding Sayth On Sat, 13 Dec 2014 9:06 AM Larry Martell larry.mart...@gmail.com wrote: On Fri, Dec 12, 2014 at 4:52 PM, Sayth Renshaw flebber.c...@gmail.com wrote: So

Xml data import

2014-12-11 Thread Sayth Renshaw
What is the best way to manage xml data feeds with mysql? I have an xml data feed with xsd, it's complex in elements not size. Wray are the best way to get data into mysql, do I have to hack with xquery? My goal is to be able create queries and send csv files out for analysis in R and plots in