When I tried loading data using the following command from command line:
mysqlimport DatabaseName tablename.txt
I 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



Reply via email to