I used the perl exec command to run 'mysql --help'. The returned info says that the client version is 3.23.49. The local infile option was not listed in the help.
I assume the client needs to be started like mysql --local-infile=1 ? And if local infile is disabled wouldn't I get a different error message then can't get stat of 'filename' (Errcode 2)? Thanks for your help and patience Darren ----- Original Message ----- From: "Fiasco" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, April 20, 2002 7:36 PM Subject: Fw: Re: problem with load data local infile > > ----- Original Message ----- > From: "Fiasco" <[EMAIL PROTECTED]> > To: "Paul DuBois" <[EMAIL PROTECTED]> > Sent: Saturday, April 20, 2002 7:28 PM > Subject: Re: Re: problem with load data local infile > > > > > > > > > >The error I receive is: > > > >Can't stat file 'filename' (errcode 2) > > > > > > It can't stat *filename*? Don't make up error messages, report them > > exactly. > > > > > > > Can't get stat of 'filename' (Errcode 2) > > Filename being the fully qualified path of whatever file I am trying to > > infile. > > > > > > > >I tried local infiling the following two files > > > >/usr/bin/znew (exists on both machines) > > > >/usr/games/worms (exists only on client machine) > > > > > > What are the modes on both files? > > > > > > > Both files are world readable. > > > > > > > > > >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. > > > > > > Then its mode is probably different. Perhaps execute-only. > > > > Modes are the same. > > > > > > > > > > > > >It looks like the LOCAL argument is being > > > >ignored all together. > > > > > Mmm ... doubt it. > > > > Why is the load data local infile statement successfully importing files > > that reside > > on the mysql host but not the mysql client machine? With local specified, > > the host > > shouldn't even be looking for files located on it should it? > > > > > > > > > > > > >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 > > > > > > Invoke the mysql_get_client_info() function. It'll tell you > > > the version of the client library. > > > > I only have access to the database via perl or php. How do I call > > the C API function mysql_get_client_info() from perl? > > > > > > > > It's entirely possible, likely even, that the client library has been > > > updated. But based on your /usr/bin/znew, /usr/bin/games experience, > > > that seems unlikely. > > > > > > > > > > >Is there a way to find out what startup options > > > >were specified for Mysql through perl dbi or > > > >php access? > > > > > > Not that I know of. > > > > > > >----- 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 > > --------------------------------------------------------------------- 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