On Windows, I can use this statement to load XML data into the database:
LOAD XML LOCAL INFILE 'c:/users/yourname/desktop/myfile.xml' INTO TABLE MyTable ROWS IDENTIFED BY '<product>'
However, I cannot seem to accomplish this on Ubuntu 11.2.0 with the latest version of MySQL community server installed.
This is the statement I use for my Ubuntu setup:
LOAD XML LOCAL FILE '/home/ryan/tech.xml' INTO TABLE `t` ROWS IDENTIFIED BY '<product>';
So my question is, where do I put the XML files on my web server if I want to access them with MySQL?