load data local infile

[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


-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: load data local infile

[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 Guo wrote:


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.






-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

create table w/ data/index directory

[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 
varchar(10), primary key (col1), index idx1 (col2)) DATA_DIRECTORY=/tmp;
ERROR 1064: You have an error in your SQL syntax near 
'DATA_DIRECTORY=/tmp' at line 1



-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php