I'm not sure how MySQL works under Windows, but you should either use
double backslashes (\\) instead of single backslashes or use forward
slashes (/) instead. MySQL is trying to escape your string.
Cheers,
Marco
--
------------
php|architect - The Magazine for PHP Professionals
The monthly magazine dedicated to the world of PHP programming
Check us out on the web at http://www.phparch.com!
--- Begin Message ---
Off topic but I hope somebody can help.
Using MS Win98 / mySQL.
I'm trying to use LOAD DATA INFILE and coming up empty.
My text file is named:
....................
test.txt
..................
and is stored in C:\TextFiles
on the command line I type:
..............................
mysql> LOAD DATA INFILE "C:\TextFiles\test.txt" INTO TABLE tony;
...............................
I get:
ERROR 1105 File c:\TextFile\ est.txt not found (Errcode:2)
\\please note that the "t" in test is not there.
Any help would be greatly appreciated.
Happy holidays,
Tony Ritter
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
