Re: LOAD DATA LOCAL INFILE

Am 2004-08-16 19:11:50, schrieb James Hatridge: > 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, What about: http://www.ispirer.com/doc/sqlways36/troubleshooting/mysql_db.html In MySQL 4.0.x LOCAL will only work if MySQL server was started with --local-infile=1. > JIM Hello, Greetings Michelle -- Linux-User #280138 with the Linux Counter, http://counter.li.org/ Michelle Konzack Apt. 917 ICQ #328449886 50, rue de Soultz MSM LinuxMichi 0033/3/88452356 67100 Strasbourg/France IRC #Debian (irc.icq.com)