Re: mysql dump

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" <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 >