Jump to content

Enable Local Infile


scottybwoy

Recommended Posts

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.