I'm working with MySQLrefman-5.0 and running MySQL 5.0.51a. When I try to use the command as indicated in the tutorial in Ch. 3, I get the message that "this command is not allowed with this version." In section 5.6.4 of the manual it talks about enabling Load Data Local. But I'm not understanding it.
The manual says, "By default, all MySQL clients and libraries in binary distributions are compiled with the --enable-local-infile option." So why can't I use that command? (I did not build it from source but installed it using Yast.)
A bit further the manual says, "For the mysql command-line client, LOAD DATA LOCAL can be enabled by specifying the --local-infile[=1] option." But it doesn't say where to specify it. I tried including it in my command to start mysql but got a syntax error message.
eric@linux-pczd:~> mysql --local-infile[=1] -u eric -p
mysql: unknown variable 'local-infile[=1]'
I also tried restarting mysqld with the --local-infile=1 option. That command seemed to work. But I still can't use the Load Data Local command, so something is still wrong on the client side, I guess. (Client and server are on the same host.)