Re: [mysql-php] mysqlimport error
[EMAIL PROTECTED] wrote: is that a problem? I want to avoid ftp db.txt files and then mysqlimport them You should run mysqlimport on the Windows box and specify MySQL server host with -h option. - Original Message - From: Egor Egorov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, June 02, 2004 4:38 PM Subject: Re: [mysql-php] mysqlimport error nikos [EMAIL PROTECTED] wrote: I'm trying mysqlimport --local -d --fields-enclosed-by=| --fields-terminated-by=; - -lines-terminted-by=\n -unikos -p mydb c://temp//programs.txt but i get an Error: File 'c:/temp/programs.txt' not found (Errcode: 2), when using table: programs What I'm doing wrong? RH-9 - APACHE v2 - mysql 3.23.54 Looks like you run mysqlimport on the server host but file is located on Windows box. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: [mysql-php] mysqlimport error
is that a problem? I want to avoid ftp db.txt files and then mysqlimport them - Original Message - From: Egor Egorov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, June 02, 2004 4:38 PM Subject: Re: [mysql-php] mysqlimport error nikos [EMAIL PROTECTED] wrote: I'm trying mysqlimport --local -d --fields-enclosed-by=| --fields-terminated-by=; - -lines-terminted-by=\n -unikos -p mydb c://temp//programs.txt but i get an Error: File 'c:/temp/programs.txt' not found (Errcode: 2), when using table: programs What I'm doing wrong? RH-9 - APACHE v2 - mysql 3.23.54 Looks like you run mysqlimport on the server host but file is located on Windows box. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[mysql-php] mysqlimport error
Hello list I'm trying mysqlimport --local -d --fields-enclosed-by=| --fields-terminated-by=; - -lines-terminted-by=\n -unikos -p mydb c://temp//programs.txt but i get an Error: File 'c:/temp/programs.txt' not found (Errcode: 2), when using table: programs What I'm doing wrong? RH-9 - APACHE v2 - mysql 3.23.54 Thanx -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: [mysql-php] mysqlimport error
nikos [EMAIL PROTECTED] wrote: I'm trying mysqlimport --local -d --fields-enclosed-by=| --fields-terminated-by=; - -lines-terminted-by=\n -unikos -p mydb c://temp//programs.txt but i get an Error: File 'c:/temp/programs.txt' not found (Errcode: 2), when using table: programs What I'm doing wrong? RH-9 - APACHE v2 - mysql 3.23.54 Looks like you run mysqlimport on the server host but file is located on Windows box. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysqlimport error
Good morning, We recently put a new server online (FreeBSD) with MySQL version 4.0.15. I have a couple of AWK scripts which used to work properly (on another FreeBSD server with 3.23.n MySQL) with mysqlimport. Now I am getting the following error... /usr/local/bin/mysqlimport: Error: The used command is not allowed with this MySQL version, when using table: tblClass10 I have googled and found that adding the -L (for Local) to the line; /usr/local/bin/mysqlimport --host=server --user=user --password=*** -f --fields-terminated-by=\t crm tblClass10.tmp may fix this, but I couldn't get a clear explanation for why. Are there any other problems with the upgrade that I should be aware of? Thanks! Jay -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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]
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]
mysqlimport error
we get a strange error when trying to import data into our database: mysqlimport: Error: Can't get stat of 'KUNDEN' (Errcode: 13), when using table: KUNDEN it is NO permission Problem, the file ist world readable and the user CAN access the DB. any hints what else could be the problem ??? Version: mysql 3.23.54 OS: SuSE-Linux 7.0 Kernel: 2.2.16 regards -- Stefan Immel |N|O|C Network Operation Center -+-+-+--- | Grove Auf der Stuecke 6Tel. +49 2773-8167-0 35708 Haiger / Germany Fax +49 2773-8167-20 -- mailto:[EMAIL PROTECTED] http://www.grove.de There is always hope, only because it is the one thing nobody's figured out how to kill yet. ~ Galen, Crusade Racing The Night -- http://www.nocr2.de - NOC R2 die Lösung für den IT-Workflow -- - 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
RE: mysqlimport error
it is NO permission Problem, the file ist world readable and the user CAN access the DB. stupid me, it WAS a permission problem. The permission for a directory in the path wasn't right. sql, mysql or what else the spam filter needs. - 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
re: mysqlimport error
On Tuesday 18 February 2003 12:08, Stefan Immel wrote: we get a strange error when trying to import data into our database: mysqlimport: Error: Can't get stat of 'KUNDEN' (Errcode: 13), when using table: KUNDEN it is NO permission Problem, the file ist world readable and the user CAN access the DB. Check if the user that mysql server is ran under has permission to the file, and check also privileges on the directories. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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
mysqlimport: Error: The used command is not allowed with this MySQL version, when using table
Hello to everybody, I installed mysql ver 11.17 distrib 3.23.49a on redhat 7.2. I would like to import data into database table using command line instructions. I tried mysqlimport but I got the following error messagge mysqlimport: Error: The used command is not allowed with this MySQL version, when using table I looked up for the new command on the online documentation but I wasn't able to find anything and the mysqlimport command was not said to be dismissed. In the mysql mailing list repository I found an e-mail reporting the same error but on a windows operating system. Can anybody give me some suggestions on how to solve this problem? Thank you very much in advance for your time Bye Lana __ Scarica il nuovo Yahoo! Messenger: con webcam, nuove faccine e tante altre novità. http://it.yahoo.com/mail_it/foot/?http://it.messenger.yahoo.com/ - 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
Re: mysqlimport error!
That means the server does not have permission to read the file. James E. Hicks III wrote: What exactly does this error mean? mysqlimport: Error: Can't get stat of '/home/jameshicks/NONSTOCK' (Errcode: 13), when using table: NONSTOCK James mysql - 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 -- Gerald L. Clark [EMAIL PROTECTED] - 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