LOAD DATA LOCAL INFILE usdd command is not allowed in this version of mysql

[simonjones]

Hi I am trying to unpack a csv file using LOAD DATA LOCAL INFILE
I get the error
used command is not allowed in this version of mysql

I changed my.conf to allow it but it will not work?

 

[zEitEr]

Hello,

Did you restart mysqld? What do you have in php.ini

[my@server ~]$ php -i | grep infile
mysql.allow_local_infile => On => On
mysqli.allow_local_infile => On => On
[my@server ~]$

 

[simonjones]

Yes i restarted

Yes i restart it every time i update something and the httpd server

This is what the command returned so it is on

[root@server ~]# php -i | grep infile
PHP Warning:  Unknown: Invalid date.timezone value 'MSK', we selected the timezone 'UTC' for now. in Unknown on line 0
mysql.allow_local_infile => On => On
mysqli.allow_local_infile => On => On
[root@server ~]#

 

[zEitEr]

By the way what is your MySQL version?

It is said here:

if LOAD DATA LOCAL is disabled, either in the server or the client, a client that attempts to issue such a statement receives the following error message:

ERROR 1148: The used command is not allowed with this MySQL version

http://dev.mysql.com/doc/refman/5.0/en/load-data-local.html

 

[simonjones]

server version

I am using MySQL 5.0.67

 

[zEitEr]

Check then please in phpMyAdmin or on console what value has it for local-infile