Re: Problem dealing with load data

2002-07-12 Thread Gerald Clark
The server must be able to read the file, and since the server normally runs as the user 'mysql', it will not be able to read files sitting in root's home directory. Put the file in /tmp, and make it readable by others. Sofiane FAESSEL wrote: > hello everybody > I have a problem using mysql and

Re: Problem dealing with load data

2002-07-12 Thread Egor Egorov
Sofiane, Friday, July 12, 2002, 2:07:00 PM, you wrote: SF> hello everybody SF> I have a problem using mysql and the load data infile command. i have all my SF> data in a text file tabulated and using load data as it is documented i SF> receive this message SF> "ERROR 13: Can't get stat of '/roo

Problem dealing with load data

2002-07-12 Thread Sofiane FAESSEL
hello everybody I have a problem using mysql and the load data infile command. i have all my data in a text file tabulated and using load data as it is documented i receive this message "ERROR 13: Can't get stat of '/root/essai.txt' (Errcode: 13)" here is the command i use mysql> load data infil