Sorry if I was a bit fuzzy...
You have to escape out the "\" by typing "\\", so in your exaple it
would say:
LOAD DATA LOCAL INFILE 'c:\\Windows\\Temp\\phpC021.TMP' INTO TABLE
my_contact
FIELDS TERMINATED BY ';' ENCLOSED BY '\"' ESCAPED BY '\\' LINES
TERMINATED
BY '\n'
Since you get the error:
MySQL said: File 'c:windowstempphpc021.tmp' not found (Errcode: 2)
you might see that it took away the backslashes?? If you don't know why,
take a look at php manual Chapter 6. Types and the page about Strings.
Happy hunting
/Johan
Giro De Roover wrote:
>
> How is that done and where ??
>
> "Johan Lundqvist" <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > Hi Giro,
> >
> > You'll have to type c:\\Windows\\Temp\\phpC021.TMP
> >
> > /Johan
> >
> > Giro De Roover wrote:
> > >
> > > Hi everyone,
> > >
> > > I am experiencing problem with mysql trying to import a text file with
> data
> > > into a table, i am using phpmyadmin in order to do that, going to insert
> > > textfiles into table and after choosing the file I want to upload i got
> this
> > > error, any help will be appreciated.
> > >
> > > Giro
> > >
> > > Error
> > > SQL-query:
> > >
> > > LOAD DATA LOCAL INFILE 'c:\Windows\Temp\phpC021.TMP' INTO TABLE
> my_contact
> > > FIELDS TERMINATED BY ';' ENCLOSED BY '\"' ESCAPED BY '\\' LINES
> TERMINATED
> > > BY '\n'
> > > MySQL said: File 'c:windowstempphpc021.tmp' not found (Errcode: 2)
> > >
> > > --
> > > PHP Windows Mailing List (http://www.php.net/)
> > > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > > For additional commands, e-mail: [EMAIL PROTECTED]
> > > To contact the list administrators, e-mail: [EMAIL PROTECTED]
> >
> > --
> > PHP Windows Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]
> >
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
