Posted by Thomas Bartkus on 11/22/05 19:45

<nsh@starnetwx.net> wrote in message
news:1132670612.973166.204900@g49g2000cwa.googlegroups.com...
<snip>

> does "LOAD DATA" EVER work?!? I've tried EVERYTHING!

Okay - Now calm down!

> ** - If I use phpmyadmin, and insert the above command into a sql
> window & execute it - IT WORKS PERFECTLY!!

There's you - answering your own question.

It will work *every time* you throw a properly formed LOAD DATA command at
MySQL.
And obviously, you haven't tried everything everything after all!

To troubleshoot, I might suggest -

That you dump (and examine!) the exact contents of $qry as it exists just
before you pass it to mysql_query(). You might compare it *very carefully*
with the string that you know works when you pass it to mysqladmin.

Another thing that comes to mind -

Are you working with the same usr/pwd/permissions in mysqladmin that you are
working with in your PHP code. It's possible you have the FILE privelege
under mysqladmin that you lack from inside your PHP code.

Post the exact contents $qry here (not your PHP assignment code!) if
something above doesn't smack you in the face with the error of your ways
:-)

-Thomas Bartkus

[Back to original message]