Re: mysql dump

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