Load Data Infile

bizshop

Hopefully someone else has done this before

Trying to make script to Load Data Infile.
If I input

LOAD DATA INFILE '/usr/local/etc/httpd/htdocs/datatemp/additions' INTO Table ItemsTest FIELDS Terminated by ',' OPTIONALLY ENCLOSED BY '\"' LINES TERMINATED BY '\n'

directly it works fine. If I enclose that as

$query="LOAD DATA INFILE '/usr/local/etc/httpd/htdocs/datatemp/additions' INTO Table ItemsTest FIELDS Terminated by ',' OPTIONALLY ENCLOSED BY '\"' LINES TERMINATED BY '\n'";
$result=mysql_query("$query");

nothing gets inserted.

I'm sure it has to do with slashes and such, but have been fumbling around getting no closer. Hopefully somebody has written such a query that can give me a nudge.

Anon

have you tried echoing the sql command on the php page and then cut and paste it directly into the terminal?
Also, you may have a premission problem but from what I remember, that would have been printed out on the php page.

Anon

I think the problem might be the way you invoke the mysql_query() function...that function takes two parameters, the query, and the database connection ID. So, you'd need to type something like:
mysql_query("your query here", $link);

Where $link was the result of the mysql_connect() and mysql_select_db() functions.

bizshop

Yes, I've copied the echo and pasted into a phpMyAdmin query textarea and it worked. But doesn't work in the script. I've been trying to decipher how phpMyAdmin does it, but one script calls another that calls another and seems too complex for me to follow.

Anon

I had the same problem trying to figure out how phpmyadmin does it.

Try saving your query in a text file saved as .sql. Then use the the query:

mysql_query(". myfilelocation\myfile.sql", $link_id);

Its a long shot but it might just work!!

Anon

I have the some problem with Informix.
This is my code:

$query1 = "LOAD FROM '".addslashes($file_name)."' INSERT INTO load_tmp(srcaddr,
input, output, srcport, dstport, protocol, pkts, octets, flows);";

$rid1 = ifx_query($query1, $conn_id);

I set up a valid file name, and my Query
successful perfomed by dbaccess. (informix SQL utility).

Shane McHale wrote:

I had the same problem trying to figure out how phpmyadmin does it.

Try saving your query in a text file saved as .sql. Then use the the query:

mysql_query(". myfilelocation\myfile.sql", $link_id);

Its a long shot but it might just work!!