On 4/9/2002 9:41 AM, "Paul DuBois" <[EMAIL PROTECTED]> wrote:
> At 9:31 -0700 4/9/02, Jim Dickenson wrote: >> 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. > > Heh. Wait until you start running about 10 different versions. :-) > >> >> >>>> >>>> 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. > > I always compile my own. Is there some reason you don't do that? There are many messages on this list that say "use the binary from MySQL". It makes since to me to use "official" binaries so I do not end up with unique problems because of some option or compiler difference. I was just wondering why there is a version 3.23.49 that maybe runs on Mac OS X server but not one that runs on regular Mac OS X. I reported the missing library if I try to use the 3.23.49 version intended for server. -- 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