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