I ran into this too. I assume it is a limitation on the free version of MySQL, and that you have to pay to use "load data" in an SQL script. To import my data files, I use the "mysqlimport" function from the command line or batch file. It seems to support most of the "load data" options.
----- Original Message ----- From: mysql To: mySQL List Sent: Tuesday, June 24, 2003 12:02 AM 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?
