Re: mysql dump

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" <johan@noatun.org> wrote in message news:3AF10852.95730143@noatun.org... > 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" <johan@noatun.org> wrote in message > > news:3AEFF6A4.23E9B67F@noatun.org... > > > 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: php-windows-unsubscribe@lists.php.net > > > > For additional commands, e-mail: php-windows-help@lists.php.net > > > > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > > > > > -- > > > PHP Windows Mailing List (http://www.php.net/) > > > To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net > > > For additional commands, e-mail: php-windows-help@lists.php.net > > > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > > > > > > -- > > PHP Windows Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net > > For additional commands, e-mail: php-windows-help@lists.php.net > > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net > For additional commands, e-mail: php-windows-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >