Re: load data infile file location???

2002-04-12 Thread Steven Hajducko
Hey BJ, Can the mysql user actually get into that directory ('/home/user/directory')? If the mysql user can't read that directory, then it doesn't matter than it owns that file. You might want to check, do an 'su - mysql' ( replace mysql with whatever user is running the mysql daemon ), then tr

Re: load data infile file location???

2002-04-12 Thread Jim Dickenson
Did you try load data local? That way, as I understand things, the server is not reading the data the client is. On 4/12/2002 1:26 PM, "BJ Phillips" <[EMAIL PROTECTED]> wrote: > I can load files from '/home/mysql' but when trying to do it from any other > user ('/home/user/directory'), I get a

Re: load data infile file location???

2002-04-12 Thread Christopher Thompson
On Friday 12 April 2002 2:26 pm, BJ Phillips wrote: > I can load files from '/home/mysql' but when trying to do it from any other > user ('/home/user/directory'), I get an error 13 about cannot get stat on > file such and such. The files are located on the server and are owned by > the user, both

load data infile file location???

2002-04-12 Thread BJ Phillips
I can load files from '/home/mysql' but when trying to do it from any other user ('/home/user/directory'), I get an error 13 about cannot get stat on file such and such. The files are located on the server and are owned by the user, both mysql user and the system user. I specify the full path to