OK I got it but it was painfull.
In first place, I read somewhere that the latest release og phpMyadmin had
fixes the backslash story and it is not true
There is no way of having working now. In first place phpmyadmin keeps
referring to a .TMP files which
I haven't choose and don't even exist. The text file i want to upload is
update.txt and is located in My Documents
So this what I did:
1/ save my file on .txt extension with fied delemited by tabs (no commas or
others quote)
2/Make that you leave the first column empty , because mysql will add the ID
field in case you don't have one (if ID is the primary and auto_increment
3/open a console and launch mysql, select your database
ie: use test
and type
load data local infile 'c:\\My Documents\\update.txt' into table
my_contact;
this is it, it WORKS !!!!!!
Thanks for your help I hope that my suffering will help someone out there
Giro
Open a console
"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]
