----- Original Message ----- From: "Fiasco" <[EMAIL PROTECTED]> To: "Paul DuBois" <[EMAIL PROTECTED]> Sent: Saturday, April 20, 2002 6:28 PM Subject: Re: Re: problem with load data local infile
> The error I receive is: > Can't stat file 'filename' (errcode 2) > > I noticed what you mentioned about disabling > local in the documentation but I am using mysql > verson 3.23.23-beta (host) not sure what the client > is. > > Which can't stat the file, the MySQL host server, > or the MySQL client? > > I did some more testing. > > I tried local infiling the following two files > /usr/bin/znew (exists on both machines) > /usr/games/worms (exists only on client machine) > > Even though I specified local on the infile > statement, mysql successfully imported > /usr/bin/znew into the specified table. > /usr/games/worms was returned the same > can't stat file (errcode 2) message. > > It looks like the LOCAL argument is being > ignored all together. > > Is it posible that my host is 3.23.23-beta, and > that my client is a newer version of mysql and > that the client has local disabled? Whats the > quickest way to find the version of my client? I only > have access to mysql through perl/php > > Is there a way to find out what startup options > were specified for Mysql through perl dbi or > php access? > > ----- Original Message ----- > From: "Paul DuBois" <[EMAIL PROTECTED]> > To: "Darren Vollmer" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; "Victoria > Reznichenko" <[EMAIL PROTECTED]> > Sent: Saturday, April 20, 2002 5:12 PM > Subject: Re: Re: problem with load data local infile > > > > At 6:34 -0500 4/20/02, Darren Vollmer wrote: > > >The file is in a world readable directory tree. > > > > > >Shouldn't the LOCAL qualifier make mysql read the file from the client > > >running and not the host? > > > > > >I tried to LOAD DATA LOCAL INFILE on using the name (and no path) of a > mysql > > >FRM file that is in the databases directory on the Mysql host. The > server > > >found the file even though I specified local. Don't know if that means > > >anything or not, or if that is normal mysql behavior. > > > > > >exp; > > >load data local infile 'table.frm' replace into table testtable > > > > > >Shouldn't mysql be looking for table.frm on my client machine and not the > > >server? > > > > LOCAL requires only that you be able to read the file. > > > > With the LOCAL keyword, the program on the client machine reads the file > > and sends it to the server to be inserted into the table. The MySQL > server > > takes those records, and it's what accesses the table.frm file. > > > > How could the client access table.frm? That file isn't even on the client > > host necessarily. > > > > Something that might account for the difficulty, if you've upgraded MySQL > > recently: > > A change was made in MySQL 3.23.49 that causes LOCAL to be disabled (by > > default?). You may be able to re-enable it by invoking mysql with the > > --local-infile option. Try mysql --help to see if that option is listed > > in the help message. > > > > By the way, what was the error message you got? > > > > > > > > > > >----- Original Message ----- > > >From: "Victoria Reznichenko" <[EMAIL PROTECTED]> > > >To: <[EMAIL PROTECTED]> > > >Sent: Saturday, April 20, 2002 6:14 AM > > >Subject: Re: Re: problem with load data local infile > > > > > > > > >> Darren, > > >> Saturday, April 20, 2002, 1:23:54 PM, you wrote: > > >> > > >> DV> The file does exist. The file and its directory are 0777 > permission. > > >> > > >> Such permissions are setting on all dirs, that contain path to your > > >> dir? > > >> Don't forget that you should have permissions to go through dirs ... > > >> > > > > DV> Darren > > > > > > --------------------------------------------------------------------- > > 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 > > > > > --------------------------------------------------------------------- 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