upload text file into MySQL database

[Lee Kim Hock]

Hi, I am really new with PHP and MySQL. My problem is when I run the
following script in the PHP program, nothing is uploaded even though I have
45K records in the filename.txt.

load data file 'filename.txt' into table tablename fields terminated by ','
enclosed by '"' lines terminated by '\n';

When I use the Mysql prompts, it works, when I transfer the script to PHP
program, it does not work. Anything wrong with the script? Or am I missing
some PHP command?

Thanks very much

Mr. Lee Kim Hock

[Colin McKinnon]

Lee Kim Hock wrote:

> Hi, I am really new with PHP and MySQL. My problem is when I run the
> following script in the PHP program, nothing is uploaded even though I
> have 45K records in the filename.txt.
>
> load data file 'filename.txt' into table tablename fields terminated by
> ',' enclosed by '"' lines terminated by '\n';
>
> When I use the Mysql prompts, it works, when I transfer the script to PHP
> program, it does not work. Anything wrong with the script? Or am I missing
> some PHP command?
>

Using same database server/authentication details?

Got a connection to the database you can run a 'SELECT....' from?

escaping quotes?

HTH

C.