Enable Local Infile

[scottybwoy]

Hi,

 

I'm using MySQL v5.0.18 and I want to enable local infile so I can use LOAD DATA LOCAL.  So far I get this error :

1148 - The used command is not allowed with this MySQL version

LOAD DATA LOCAL INFILE 'C:\Apache\Apache2\htdocs\klickshopping\download/product.list' INTO TABLE temp_ice_product_list

 

I have tried putting these :

mysql> --local-infile=1
mysql> --local 

Into the mysql command prompt, which didn't seem to do anything.  Is there a way of doing this Without recompiling mysql?

 

This is on my test server, but when I deploy it on the GoDaddy host site, will I just have to ask if they support this feature?

 

Thanks

[PFMaBiSmAd]

Putting those statements on the mysql command prompt only enables LOAD DATA LOCAL for the command-line client, for that command line session.

 

You need to find out if it is php or your mysql server where the LOAD DATA LOCAL command is disabled. Describe your test server. Operating system? Where and how you got php and mysql? What version of php?

 

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

[scottybwoy]

OK,

 

Well my test server (the one I'm trying this out on) is :

Windows XP

Apache2

Php 4.4.8

MySQL 5.0.20

 

The host server I ultimately want to be running this script on is GoDaddy :

Linux

Apache2

Php 4.3.11

Mysql 5.0.18

 

What do you mean, where I got php?  How do I find out if it is php that is blocking this function?  Is there a command I can invoke to tell me if it is enabled/disabled?  Will I have to ask GoDaddy if I can use this command as I believe they don't have the mysqli extension.

 

Thanks.