Re: LOAD DATA LOCAL INFILE

Hi Dani et al.. The guys at MySQL turned this off for security reasons. :( They and SuSE say that you can turn it back on, but I've never been able to get it to work. There are two ways to handle this, first you have to use "LOAD DATA INFILE". The file then needs to be either in /tmp and readable by everyone (this is best). Or the way I do it is put in the same dir where the database is, ie /var/lib/mysql/databaseXXX. The problem with this is that you have to change the premissions. Which is not a good idea on an internet machine. Hope this helps, JIM On Monday 16 August 2004 14:40, Daniel Kradolfer wrote: > Hello > > I'm new to this list. I diden't found anything in the archive and by > googleing to solve my problem. > > We have updated our server to PHP 4.3.8 and MySQL 4.0.2. Some of our > clients run a shop software that need 'LOAD DATA LOCAL INFILE' to store > its data to MySQL. MySQL itself supports the command. I can run it from > mysql-client. That works. I have read about the fix on php.net > (http://www.php.net/ChangeLog-4.php / > http://bugs.php.net/28632). > Until now, i couldn't find a solution to get it work. > > Is there way to get it work? > > Regards > Dani -- Jim Hatridge Linux User #88484 ------------------------------------------------------                  BayerWulf            Linux System # 129656          The Recycled Beowulf Project   Looking for throw-away or obsolete computers and parts    to recycle into a Linux super computer WartHog Bulletin Info about new German Stamps http://www.fuzzybunnymilitia.org/~hatridge/bulletin Viel Feind -- Viel Ehr' Anti-US Propaganda stamp collection http://www.fuzzybunnymilitia.org/~hatridge/collection