By default, "LOAD DATA INFILE ..." is disabled (I am not sure from which version). You may need to compile MySQL with “-enable-local-infile". You may find details on www.mysql.com .
Ruth ----- Original Message ----- From: "mysql" <[EMAIL PROTECTED]> To: "mySQL List" <[EMAIL PROTECTED]> Sent: Tuesday, June 24, 2003 2:02 PM Subject: Q: LOAD DATA command error I use version 4.0.12-max-debug. mysql> returns the following error code when I use the load data command. mysql> load data local infile "foo.txt" into table pet; ERROR 1148: The used command is not allowed with this MySQL version Do I need to upgrade to a new version? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]