Re: load data infile --- problem

2002-08-13 Thread LR P
thanx 4 your reply: this is the error message that i got when i tried using the full pathname. mysql> LOAD DATA INFILE "/home/ihot/member.txt" INTO TABLE member; ERROR 13: Can't get stat of '/home/ihot/member.txt' (Errcode: 13) mysql> i've tried using another user account (of course i've set a

load data infile --- problem

2002-08-12 Thread LR P
hi all, i have a problem with "load data..." statement. i'm using MySQL 3.23.49 from RedHat 7.3. i read Paul DuBois book about MySQL, and tried to load data to my member table, mysql> LOAD DATA INFILE "member.txt" INTO TABLE member; but i didn't work. i've tried by removing the 'local', but i