Hummmm,
After trying this:
CREATE PROCEDURE `M4E`.`Load_BestDeals` ()
BEGIN
LOAD DATA LOCAL INFILE '/usr/share/tomcat6/webapps/ROOT/bestdeals.txt'
INTO TABLE BestDeals FIELDS TERMINATED BY 'r' (DealID, DealType);
END
I was informed by my MySQL WorkBench application that LOAD is not allowed
in stored procedures so that rules that option out.
Regards,
Lee
On Monday, March 5, 2012 1:17:38 PM UTC, Lee wrote:
>
> All ticked in OpenBD admin for the datasource, will give the SP a go after
> lunch.
>
> On Monday, March 5, 2012 12:54:34 PM UTC, Lee wrote:
>>
>> 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
