Menu
▾
▴
RE: [base] local-infile option
|
From: joe d. <jo...@uc...> - 2002-11-18 00:44:02
|
Hi, it looks like Audrey and I have exactly the same problem. I can load loc= al data infile fine when I am logged into mysql as root or Base, but Base itself cannot do this. Just to clarify then, Jim you are suggesting the compile mysql from sourc= e (the tarball...?) with the --enable-local-infile during the install. So = the RPM has it turned off in some irreversible way, but only for PHP clients? I have to admit, I am pretty new to linux and mysql, but why does Base ne= ed to do load data local infile instead of just doing load data infile, and giving the baseuser file priviledge in mysql? The file being loaded is in= a tmp directory on the server anyway, right? I guess bottom line I will do what ever is the fastest thing to get this = up and running. Do I need to uninstall the old RPM of mysql first, or while the new server just write over it? Thanks for any advice you all can give me, joe -----Original Message----- From: bas...@li... [mailto:bas...@li...]On Behalf Of James MacDonald Sent: Wednesday, November 13, 2002 6:15 AM To: bas...@li... Subject: Re: [base] local-infile option I couldn't ever get the local-infile option to work either. I ended up having to compile from source (which is much more fun anyway ;-D). If you take this option, remember to add --enable-local-infile to your configure statement. Jim James W. MacDonald UMCCC Microarray Core Facility 1500 E. Medical Center Drive 7410 CCGC Ann Arbor MI 48109 734-647-5623 >>> abi...@na... 11/12/02 12:41PM >>> Hello, I used RPM to install Mysql (v 3.23.53a) and apparently, the local-infile option is disable. so I can't use LOAD DATA LOCAL. I try to add the line "local-infile=3D1" in the my.cnf file as indicated = in the BASE README file, but it doesn't work. How can I get through it ? Thanks. *-----------------------* Audrey Bihouee INSERM U533 Facult=E9 de m=E9decine, 1, rue Gaston Veil 44035 Nantes Cedex 1 Tel : 02.40.41.29.86 *-----------------------* ------------------------------------------------------- This sf.net email is sponsored by: Are you worried about your web server security? Click here for a FREE Thawte Apache SSL Guide and answer your Apache SSL security needs: http://www.gothawte.com/rd523.html _______________________________________________ basedb-users mailing list bas...@li... https://lists.sourceforge.net/lists/listinfo/basedb-users ------------------------------------------------------- This sf.net email is sponsored by: Are you worried about your web server security? Click here for a FREE Thawte Apache SSL Guide and answer your Apache SSL security needs: http://www.gothawte.com/rd523.html _______________________________________________ basedb-users mailing list bas...@li... https://lists.sourceforge.net/lists/listinfo/basedb-users |
