mysqlimport DatabaseName tablename.txtI got the following error:
mysqlimport: error : can't get stat of /home/...../tablename.txt
However, when I used the following command from mysql prompt, I was able to load the data without any problem.
mysql>load data local infile "/home/..../tablename.txt into table tablename.txt
I use MySQL 4.0.7 on Red Hat Linux.
Can anyone tell me why I have the above problem with mysqlimport and how I can fix it?
Thanks.
_________________________________________________________________
MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. http://join.msn.com/?page=features/virus
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php