Load data local
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. Quote:
Thanks. |
Quote:
If you want, you can to do the same by adding this option (add the line: local-infile=1) in the [mysqld] part of /etc/my.cnf. Regarding the client, you can also add this option in the [client] part of my.cnf. Take a look at this to see the security issues about it. Regards |
Thanks, Bathory.
I tried this and still get the same error message. Quote:
Quote:
|
I got it to work--had to specify "local-infile=1" in my command to start mysql. I was trying to specify it in the "Load Data Local Infile" command.
But once I've made the change (noted in previous post) to the client part of my.cnf, I shouldn't have to also do it when starting mysql, should I? Thanks. |
I guess that you have to specify the localt-infile option in the startup script of mysqld, because the settings in my.cnf get overwritten by the startup options.
Anyway glad to see you've made it. Regards |
All times are GMT -5. The time now is 12:00 PM. |