nellnA hciR <[EMAIL PROTECTED] said: > if you add local-infile=1 to your main my.cnf (/etc/my.cnf) under the mysqld > & mysql groups, you will be able to use load data local from the mysql > client > > contents of /etc/my.cnf > ---------------------------- > [mysqld] > local-infile=1 > > [mysql] > local-infile=1 > > - hcir > On Monday, Oct 14, 2002, at 15:46 America/Anchorage, Edward C. Jones wrote: > > > Since I have had no luck whatsoever figuring out how to use the > > "local-infile" options, I modified my Gentoo ebuild to pass > > "--enable-local-infile" to the compile configure. Do I still need to use > > local-infile options at all?
On my system the file is "/etc/mysql/my.cnf". One of the reasons I am having problems is that adding the "local-infile=1" lines doesn't work. Here are some details: I am starting mysqld with safe_mysqld --local-infile=1 & and stopping it with mysqladmin -u root --password=xxxxxxxx shutdown My program is written in Python. It worked for an earlier 3.23 MySQL. It is calling the MySQL C API using MySQLdb which is part of mysql-python (http://sourceforge.net/projects/mysql-python). I do a "LOAD DATA LOCAL INFILE" and get the well-known error mesage 1148: "The used command is not allowed with this MySQL version". Here is another strange thing: In the MySQL manual at www.mysql.com, there is a section 4.2.4 Security issues with LOAD DATA LOCAL This section is missing from the manual provided with 3.23.52. --------------------------------------------------------------------- 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