You can definitely do a "load file" from within the mysql client, so I'd
guess you can do it through mysql_query, too. I'm wondering about the
semi-colon within the query. Maybe it needs to be escaped, too.
David
> I could be 100% wrong on this, but I do not think that a command line
> statement can be executed through mysql_query() - try exec().
> If I remember correctly mysql load data infile ... is not executed from
> within mysql, but at the command line.
> (Hint: look at the source for phpMyAdmin and copy how it is done.)
> Regards - Miles
At 08:30 AM 8/18/2005, select.now wrote:
>>Helo everyone !
>>I find this problem and I think I am close to the solution but ...
>>
>>The question: I need to import a few thousand of record storee in a
*.csv
>>file on my local harddisk, with my php application, managing my mysql
engine.
>>
>>So, in command line, all works fine, all records are correctly imported.
>>---------------- <command line code> -------------------------
>> >mysql load data infile 'c:\\datastream\\import\import
>>->into table iport
>>-> fields terminated by ';'
>>-> ignore 9 lines;
>>----------------- </command line code> ------------------------
>>
>>But in my php app, because I am confuse a bit (use of ['], ["] and the
>>definition of variables in mysql_query), I don't make this import.
>>
>>------------------ <php code> -------------------
>>$a = 'c:\\\datastream\\\import\\\import';
>>$extra_arg = 'fields terminated by \';\' ignore 9 lines;';
>>$query = 'load data infile \''.$a.'\' into table import '.$extra_arg.'';
>>$result = mysql_query ($query) or die_mysql ("<br>Executia comenzii
>><i>$query</i> a esuat.<br>");
>>------------------ </php code> ----------------------
>>
>>I get this output-error:
>>===
>> load data infile 'c:\\datastream\\import\\import' into table import
>> fields terminated by ';' ignore 9 lines;
>>===
>>and the import doesn't occured.
>>
>>
>>Where is located my mistake ?
>>
>>Thanks in advance.
>>
>>--
>>cu respect, select.now@xxxxxxxxx
>>
>>--
>>PHP Database Mailing List (http://www.php.net/)
>>To unsubscribe, visit: http://www.php.net/unsub.php
