On Sun, Mar 25, 2012 at 4:19 AM, Lee <[email protected]> wrote: > What details is it you require? Could it be the mySQL admin console it is > referring to, perhaps the user does not have rights to perform that action > from a program outside the main SQL console. >
I dug into this a bit more and that error message actually comes from the OpenBD engine itself, specifically line 118 in com.naryx.tagfusion.cfm.engine.exceptionMessage. So at least we're getting somewhere. I wonder if that's the error that gets thrown when OpenBD itself sees that a setting isn't explicitly enabled (or is explicitly disabled) in the XML configuration file, so maybe in MySQL you have to explicitly grant LOAD permissions for this to work? Are you using a root user at least for testing to eliminate permission issues? Couple of threads on all of this: http://lists.mysql.com/mysql/132200 http://objectmix.com/jdbc-java/41828-jdbc-outfile-infile.html http://forums.databasejournal.com/showthread.php?t=39584 I've never used this feature of MySQL mysql but I'll try to experiment later today. > Being more of an MS SQL developer this is my first foray into mySQL so any > guidance even though it might be off topic would be appreciated. > Log into MySQL directly (i.e. not running things via JDBC) as the root user and see if you can execute the LOAD stuff that way. Did you already try that? If it works that way and not this way are you using the same MySQL user? So now I'm wondering if maybe your MySQL user doesn't have permissions to do this (are you trying this as MySQL root user or equivalent just to make sure it's not permissions on that end?) and that the error coming out of OpenBD is a bit of a red herring, although I'd think if that were the case you'd be getting the error from the JDBC driver, not the OpenBD engine. -- Matthew Woodward [email protected] http://blog.mattwoodward.com identi.ca / Twitter: @mpwoodward Please do not send me proprietary file formats such as Word, PowerPoint, etc. as attachments. http://www.gnu.org/philosophy/no-word-attachments.html -- online documentation: http://openbd.org/manual/ google+ hints/tips: https://plus.google.com/115990347459711259462 http://groups.google.com/group/openbd?hl=en
