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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]