MySQL Forums
Forum List  »  PHP

Load data infile Issue
Posted by: savinirsk
Date: August 04, 2005 01:37AM

PHP Version : 4.3.11
Mysql Version: 4.0.24-standard
Apache (unix): 1.3.33

I have a huge text file for import, but my mysql host isn't keen on giving 'FILE' privileges for me to use 'load data infile' command. I was searching around internet and I found this option where I can use the fifth parameter to use ( MYSQL_OPT_LOCAL_INFILE ) at the time of connecting to the database.

I tried it with no luck. Does it only work with mysql version lower than 4.0.2? If there is a work around using PHP script, I will appreciate it very much if anybody can point me in that direction.

BTW, I have no control over the mysql compilation.

Thanks,
Merryl.

Options: ReplyQuote


Subject
Written By
Posted
Load data infile Issue
August 04, 2005 01:37AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.