How to use mysql_init and mysql_options correctly for LOAD DATA LOCAL?

[phn737]

OK, so I have this problem with MySQL 3.23.53 (win2k) and Apache2.0.43(running as module) and PHP4.3.0(dev) (this is necessary for Apache2.0.43 to run as module; php bug). I have a script that load data from a csv file into a DB. The problem is in newer version of MySQL 'LOAD DATA LOCAL INFILE' is disable for security feature.

By adding the line below in c:\winnt\my.ini, I can use 'LOAD DATA LOCAL INFILE' from mysql client from the command prompt.
[mysql]
local-infile=1

Now I am still unable to use 'LOAD DATA LOCAL INFILE' from a php script via the webbrowser, I get this message:

The used command is not allowed with this MySQL version

MySQL online document

http://www.mysql.com/doc/en/LOAD_DATA_LOCAL.html

http://www.mysql.com/doc/en/mysql_options.html

said to use mysql_init and mysql_options, but I can't figure it out. What is the proper syntax to add this two functions before the mysql_connect to get this working properly?

Please help.
Thank you.

 

[sleipnir214]

Is the datafile on the same machine that is running MySQL? If so, don't use the "LOCAL" directive. Want the best answers? Ask the best questions:

http://www.tuxedo.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[phn737]

Yes the import.txt file is uploaded to the same directory that the php script is executing from (which is on the same machine that is hosting the apache and mysql).

So you do think I need to add the 'mysql_init' and 'mysql_options' functions into my php script?

 

[sleipnir214]

No, you do not have to add those functions.

Do not use the "LOCAL" keywork in your query.

You use "LOCAL" only when the data is sitting on one machine, and MySQL is running on another. It adds the functionality of passing the file to MySQL through the database connection. Want the best answers? Ask the best questions:

http://www.tuxedo.org/~esr/faqs/smart-questions.html

TANSTAAFL!