On Windows (r) I can this statement to load xml data in the database
LOAD XML LOCAL INFILE 'c:/users/yourname/desktop/myfile.xml' INTO TABLE MyTable ROWS IDENTIFED BY '<product>'
But, I cannot seem to accomplish this on Ubuntu 11.2.0 with the latest version of MySQl communiuty 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?