Re: load data local infile

2002-12-12 Thread Yuyi Guo
Thanks, it works after we recomplied it the enable-local-infile. By default, it is truned off. Cheers, yuyi Rich Allen wrote: try adding these line to your my.cnf file (mysql config file) [mysqld] local-infile=1 [mysql] local-infile=1 - hcir On Thursday, December 12, 2002, at 09:52 AM, Yuyi

load data local infile

2002-12-12 Thread Yuyi Guo
Hi: I am using mysql v4_0_5 both clinet and server. I cannot get load data local infile to work after many different tries. Does anyone make it work with this version? It worked for when I used v3.23.52. Thanks for any tips, Yuyi --

create table w/ data/index directory

2002-11-13 Thread Yuyi Guo
Hi, I am using Mysql version: 3.23.52 on Red Hat Linux. I tried to create a table as below and got error. Could some one point me what I did wrong? Or the DATA DIRECTORY defination does not really exist? Thanks, Yuyi Guo mysql> create table testtable2 (col1 varchar(10) NOT NULL, col2 varc