Victoria, >> LOAD DATA LOCAL INFILE "member.txt" INTO TABLE member; >> -> ERROR 1148: the used command is not allowed with this MySQL version
> Add --local-infile=0 to mysqld commandline. > See: http://www.mysql.com/doc/en/LOAD_DATA.html This doesn't work with MySQL <= 4.0.10. I reported to [EMAIL PROTECTED] that the appropriate manual section differs from the software implementation. At least for MySQL under Windows, I can tell that server and clients are apparently _not_ compiled with --enable-local-infile, so if you set --local-infile=1 (not =0 !), this will have no effect. I checked the changelogs of 4.0.11 and 4.0.12 for a bugfix, but those say nothing about that issue. Regards, -- Stefan Hinz <[EMAIL PROTECTED]> iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 [filter fodder: sql, mysql, query] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]