On 4/8/2002 7:25 PM, "Paul DuBois" <[EMAIL PROTECTED]> wrote:
> At 17:52 -0700 4/8/02, Jim Dickenson wrote: >> I am having problems getting the "load data local infile" working. >> >> I am running Mac OS X 10.1.3 build 5Q110 with all available updates >> installed. >> >> I had installed version 3.23.49 from >> http://www.entropy.ch/software/macosx/mysql/ and found that a change was >> made in verion 3.23.49 as related to the use of local files. I added >> --local-infile=1 when I run mysql and the command was accepted. The problem >> I was then having is that if I issued the following command >> >> load data local infile 'mt2308.dat' into table mt2308 ; >> >> mt2308.dat was not found. I had to specify the fully qualified file name for >> the command to work. This is a change from the way it used to work as I >> recall. It was the case that at one time this command would find the file if >> the file was in the current working directory. > > I don't have any problem with unqualified filenames under Mac OS X. > Still works like it used to. > > Perhaps --local-infiile=1 isn't actually having any effect, so the server > is still really reading the file. Do you have the FILE privilege? If > so, that might be the case. You can test that by making the file mode > 600 so it's readable only to you, and then loading the file with the > full pathname. If that's what's happening, the server will no longer > be able to read it. (Assuming it doesn't run as you.) > > I suppose another possibility is that you're not really running mysql > in the same directory where the file is located, although that seems > unlikely -- unless maybe "mysql" is actually aliases to something > weird. > I had some other version of mysql executables in /usr/local/bin so I was not running the application I thought I was. Thanks for making me look at what really got executed when I said mysql. >> >> I then went to www.mysql.com and looked at what binary distributions were >> there for Mac OS X. First I downloaded version 3.23.49 but when I tried to >> run that version /usr/lib/libpthread.A.dylib was not found. I could not find >> where I could get this library. >> >> I then picked up version 3.23.47 and although I did not need to use >> --local-infile=1 the file was not find unless I specified the fully >> qualified file name. >> >> Two questions. First, what can I do to get the MySQL version 3.23.49 working >> on my system so I have the current version of the software? Second, what can >> be done so I do not need to specify the fully qualified file name? >> This still leaves the question as to when version 3.23.49a will be compiled for Mac OS X, instead of version 3.23.47. >> >> >> Thanks for any help with these items. >> -- >> Jim Dickenson >> mailto:[EMAIL PROTECTED] >> >> Computers for Marketing Corporation >> http://www.cfmc.com/ >> >> eFax: 1-419-791-8924 > > > --------------------------------------------------------------------- > 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 -- Jim Dickenson mailto:[EMAIL PROTECTED] Computers for Marketing Corporation http://www.cfmc.com/ eFax: 1-419-791-8924 --------------------------------------------------------------------- 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
