RE: mysqlimport: Error: Can't get stat of
Please ignore this this problem as I found the answer. For those inquring minds, I added a -L to the mysqlimport command and we are all happy now. James -Original Message- From: James E Hicks III [mailto:[EMAIL PROTECTED] Sent: Monday, March 24, 2003 2:48 PM To: Mysql Subject: mysqlimport: Error: Can't get stat of Why am I getting this error? I have looked on google and it said to use the full path when naming the import file. I have done this and still get the error. What else could I be doing wrong? # mysqlimport -d --fields-optionally-enclosed-by=\' --fields-terminated-by=, --use r=userid --password=pword DB_2update /fullpathto/thefile.SQL mysqlimport: Error: Can't get stat of '/fullpathto/thefile.SQL' (Errcode: 13), w hen using table: thefile For the filter. sql, query -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: mysqlimport: Error: Can't get stat of
On 24-Mar-2003 James E Hicks III wrote: snipage mysqlimport: Error: Can't get stat of '/fullpathto/thefile.SQL' (Errcode: 13), when using table: thefile localhost.dread$ perror 13 Error code 13: Permission denied localhost.dread$ -- Don Read [EMAIL PROTECTED] -- It's always darkest before the dawn. So if you are going to steal the neighbor's newspaper, that's the time to do it. (53kr33t w0rdz: sql table query) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: mysqlimport: Error: Can't get stat of
You're having a permissions problem. From the Load data infile section of the manual: For security reasons, when reading text files located on the server, the files must either reside in the database directory or be readable by all. Also, to use LOAD DATA INFILE on server files, you must have the FILE privilege on the server host. Try chmoding it 666 or moving it to the same partition as your MySQL data dir. Dan -Original Message- From: James E Hicks III [mailto:[EMAIL PROTECTED] Sent: Monday, March 24, 2003 2:48 PM To: Mysql Subject: mysqlimport: Error: Can't get stat of Why am I getting this error? I have looked on google and it said to use the full path when naming the import file. I have done this and still get the error. What else could I be doing wrong? # mysqlimport -d --fields-optionally-enclosed-by=\' --fields-terminated-by=, - -use r=userid --password=pword DB_2update /fullpathto/thefile.SQL mysqlimport: Error: Can't get stat of '/fullpathto/thefile.SQL' (Errcode: 13), w hen using table: thefile For the filter. sql, query James E Hicks III Noland Company 2700 Warwick Blvd Newport News, VA 23607 757-928-9000 ext 435 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: mysqlimport: Error: Can't get stat of
Probably a permission problem. If it cannot read the file it cannot import it. monster perror 13 Error code 13: Permission denied -Original Message- From: James E Hicks III [mailto:[EMAIL PROTECTED] Sent: Monday, March 24, 2003 11:48 AM To: Mysql Subject: mysqlimport: Error: Can't get stat of Why am I getting this error? I have looked on google and it said to use the full path when naming the import file. I have done this and still get the error. What else could I be doing wrong? # mysqlimport -d --fields-optionally-enclosed-by=\' --fields-terminated-by=, - -use r=userid --password=pword DB_2update /fullpathto/thefile.SQL mysqlimport: Error: Can't get stat of '/fullpathto/thefile.SQL' (Errcode: 13), w hen using table: thefile For the filter. sql, query James E Hicks III Noland Company 2700 Warwick Blvd Newport News, VA 23607 757-928-9000 ext 435 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]