Hi Matt,
Also having the same response from the server with this statement:
I had a look at the links in the previous email but none of them led to
anywhere particularly in line with my issue, but thanks anyway.
<cfquery name="RENAME_TABLE" datasource="trains_central">
ALTER TABLE `trains_central`.`TRAIN_AuditInfo` RENAME TO
`trains_central`.`TRAIN_AuditInfo_12_04_01;
use trains_central;
delimiter $$
CREATE TABLE `TRAIN_AuditInfo` (
`AuditID` varchar(50) NOT NULL,
`ActionType` varchar(50) NOT NULL,
`AuditDT` datetime NOT NULL,
`AuditSource` varchar(50) NOT NULL,
`AuditAdditionalInfo` varchar(1000) DEFAULT NULL,
PRIMARY KEY (`AuditID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1$$
</cfquery>
The individual commands above can successfully be completed by using MySQL
workbench (equivalent of enterprise manager for MSSQL) using the same user
as I am using for the datasource on the OpenBD administration.
Kind Regards,
Lee
Regards,
Lee
On Monday, March 26, 2012 10:42:00 PM UTC+1, Matt Woodward wrote:
>
> On Sun, Mar 25, 2012 at 12:21 PM, Lee <[email protected]> wrote:
>
>> The user I am trying it as is not the ROOT user but an additional user.
>> If I login into mySQL at the command prompt as this user I am able to
>> perform the query with no issue so the user would appear to have the
>> permissions available to it to run the LOAD File statement.
>
>
> I will have to experiment since I've never used this in MySQL. Did any of
> the links I included provide any additional insight?
>
> I'll try to mess with this tonight.
> --
> 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
