Afternoon All,
Having been able to get passed the initial hurdle of using CFexecute to
extract my .gz files (Thanks Nitai!!). I have kit my next snag. I am trying
to load the data directly into the table from the file using this command.
LOAD DATA LOCAL INFILE '/usr/share/tomcat6/webapps/ROOT/bestdeals.txt' INTO
TABLE BestDeals FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n' (DealID,
DealType);
If I run this command directly from SSH logged in a the same used I have
the datasource configured to use in OpenBD I have no problem and the data
hops on in happily.
If I run a query as follows:
<cfquery datasource="m4e" name="FileUpdateAudit">
LOAD DATA LOCAL INFILE '/usr/share/tomcat6/webapps/ROOT/bestdeals.txt'
INTO TABLE BestDeals FIELDS TERMINATED BY 'r' (DealID, DealType)
</cfquery>
I get an error as follows:
SQL operation disabled via admin console
Any thoughts?
Regards,
Lee
--
online documentation: http://openbd.org/manual/
google+ hints/tips: https://plus.google.com/115990347459711259462
http://groups.google.com/group/openbd?hl=en
