sorry to be so clueless,
but i tried as you mentioned and the page reload itseld like i am doing a
reset (form type) and nothing happen.
let me give you more explanation where i am:
I am using phpmyadmin, i go to the table i want to load the data, then i
click on "insert textfile into data"
There i use the browse button to identify where my file is, actually in
c:\\My documents\\update.txt, then i submit.
In first place i don't understand why mysql is referring to a .TMP file
located in windows\temp since i tell him to load update.txt.
Secondly the .TMP doesn't exist, I went there and did not find it. Every
time i try , the .TMP change.
I am trying hard to analyse this , and it seems to me that phpmyadmin create
a temp file everytime but because he got an error did not get the change to
create it or something.
Anyway this is where I am, I hope this explanation will help you understand
my problem.
Thanks Giro
"Johan Lundqvist" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> 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]
>
--
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]
