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
>
>     ->        (`FIRSTOWNER`, `OWNER2`, `NFUL_ADDR`, `NFUL_ADDR2`, `CITY`,
> `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


Thread
used command isn not allowedGordon19 Jun
  • Re: used command isn not allowedDavid Southwell19 Jun
  • Re: used command isn not allowedMartin Gainty19 Jun