[electronico]

Hi all,

First excuse me if this thread sounds newbie, but i'm not a php-sql guru at all ...

server :
linux / redhat with kernel : 2.4.21-4.0.1.EL
Apache version 1.3.31 (Unix)
PHP version 4.3.9
MySQL version 4.0.18-standard
cPanel Build 9.9.9-STABLE 15
Theme cPanel X v2.5.0

Aim :
scan a directory, create a txt file with its content and insert it into mysql

The problem is with the txt file insertion into mysql.
For this I was using the LOAD DATA LOCAL INFILE like this :

Code:

$result = mysql_db_query($sql_db,"LOAD DATA LOCAL INFILE 'dbexport.txt' INTO TABLE $sql_tbl FIELDS TERMINATED BY ',' ENCLOSED BY '\"'") or die ("Requete DATA LOAD invalide ".mysql_errno() ." : ".mysql_error() ."");

and it was running fine.

Since mysql version has been updated to 4.0.18, I get a 1148 error : The used command is not allowed with this MySQL version

I have seeked the web for a long time and found that this function is disabled in new mysql versions for security reason.

As I can't re-compile mysql, I read that :

Code:

mysql_options(... MYSQL_OPT_LOCAL_INFILE, 0)

could be used, but I haven't been able to use it ...
Could you please assist this this ?

Now I have to download the txt file from the server and insert it from phpmyadmin , that's a real pain as previously a simple browsing was doing the job.

I was wondering if there are turnaround for this ?
And why can phpmyadmin insert this txt file upload to a /tmp/ directory and not me from a .php file ?

Thanks in advance for your time and understanding (excuse my english in case it hurts).

[Jaffizzle]

if you are looking for a mysql_db_query replacement

i believe you can use a combination of

mysql_select_db and mysql_query


Your SQL is too crazy for me..hehe im not at that level ,
so Im not 100% sure what you are trying to do. It looks like you are trying to import the .txt file via script, if so I never done that before

[electronico]

thanks for your answer.
Yes, I want to import the txt file via script and it was working with the old mysql version.

[Jaffizzle]

PHP Code:

mysql_select_db($sql_db); 



$result=mysql_query("LOAD DATA LOCAL INFILE 'dbexport.txt' INTO TABLE $sql_tbl FIELDS TERMINATED BY ',' ENCLOSED BY '\"'") or die ("Requete DATA LOAD invalide ".mysql_errno() ." : ".mysql_error() .""); 

That should be the equivalent of mysql_db_query if you didnt get it yet.