List: General Discussion « Previous MessageNext Message » From: David Southwell Date: June 19 2007 6:42pm Subject: Re: used command isn not allowed View as plain text
On Tuesday 19 June 2007 09:05:36 Gordon wrote:
> I tried running this load data command on Server version: 5.0.27 and get
> the 1148 error. I'm not sure if it is referring tho the comand client or
> the server.
>
> I also do not understand why the command {or which part} it is complaining
> about. Probably something obvious, but I just can't see it.
>
>
>
> Any suggestion will bew greatly appreciated.
>
>
>
> mysql> load data local infile "c:\\losalamos.asc" into table losalamos_new
>
>     ->        fields terminated by ',' optionally enclosed by '"' lines
> terminated by '\r\n' ignore 1 lines
>
> `STATE`, `ZIPCODE`, `FIRST_NAME`,
>
>     ->         `LOT`, `BLCK`, `TRACT`, `SUBD`, `SECTION`, `TOWNSHIP`,
> `RANGE`, `DESCRIPT`, `LAST_NAME`, `TAXAMT`,
>
>     ->         `MAPCODE`, `NUMBER`, `STREET`, `YBLT`, `MAIN`, `SECOND`,
> `THIRD`, `DOWNSTAIRS`, `TOTAL`, `DEAR`,
>
>     ->         `TRUST`, `CTYSTZIP`, `ACCT`, `ACRE`, `DEEDBOOK`, `DEEDPAGE`,
> `TAXDUE`, `TAXPAID`, `PUR_DATE`,
>
>     ->         `PROP_ZIP`, `COMPANY`, `SALUTATION`, `CONTACT`, `BEDROOMS`,
> `BATHS`, `TAXYEAR`, `UNITS`, `SALEDATE`,
>
>     ->         `ACCTTYPE`, `LANDASD`, `IMPASD`, `cntyname`, `SALEMONTH`,
> `SALEYR`);
>
> ERROR 1148 (42000): The used command is not allowed with this MySQL version

Are you using MyISAM or INNODB?

Are you using select statements concurrently?

Is the local enabled on both client and server sides?

Have you tried enclosed by ''     ?

Is the program you have used to create your infile using  the old-msdos Ctrl-Z
character?

That is all I can offer

david