Re: command is not allowed with this MySQL version
- Original Message - From: yoku ts. yoku0...@gmail.com Subject: Re: command is not allowed with this MySQL version Christophe has already told, The used MySQL version is 5.5.40 from Debian Wheezy package. No, that's the new version. It'd be fun to know what the OLD version was, too. Maybe you missed *mysql command-line client's --local-infile option* Not particularly helpful, since Christophe already said it's a PHP application :-) -- Unhappiness is discouraged and will be corrected with kitten pictures. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
[Solved] Re: command is not allowed with this MySQL version
Hi, Le 12/12/2014 11:51, Johan De Meersman a écrit : - Original Message - From: yoku ts. yoku0...@gmail.com Subject: Re: command is not allowed with this MySQL version Christophe has already told, The used MySQL version is 5.5.40 from Debian Wheezy package. No, that's the new version. It'd be fun to know what the OLD version was, too. Absolutely no idea : The app was running on a shared hosting, and don't have access to it ... Maybe you missed *mysql command-line client's --local-infile option* Not particularly helpful, since Christophe already said it's a PHP application :-) Right :) and the solve was in PHP behavior (all seems fine now ...) . The configuration was fine, but to take care of 'local-infile' parameter in PHP configuration (and on Debian) the php5-mysqlnd package must be installed instead of php5-mysql. Hoping this can help someone in the future. Regards. Christophe. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: command is not allowed with this MySQL version
2014/12/12 02:10 +0100, Christophe When the app tries to do this, it raises an error : 'The used command is not allowed with this MySQL version' The used MySQL version is 5.5.40 from Debian Wheezy package. I found that some parameters or variables (local_infile for instance) can be used to get rid of this error, but can't really find the right configuration. Well, yes, if local_infile is 0 or FALSE then 'LOCAL' is forbidden. If 'LOCAL' is not used then the MySQL user needs privilege 'FILE' to read from the server s own disk. What else have you tryed, with what outcome? because the statement as it stands is good MySQL. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
command is not allowed with this MySQL version
Hi there, One of our customers would like to modernize his IT : new servers with new OS, etc. But he got an old fashion PHP/MySQL application that make queries like this : LOAD DATA LOCAL INFILE '/files/tmp_import.csv' IGNORE INTO TABLE users FIELDS TERMINATED BY ';' LINES TERMINATED BY '\n' IGNORE 1 LINES (@dummy, nom, prenom, @dummy, @dummy, email, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy,@dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy) When the app tries to do this, it raises an error : 'The used command is not allowed with this MySQL version' The used MySQL version is 5.5.40 from Debian Wheezy package. I found that some parameters or variables (local_infile for instance) can be used to get rid of this error, but can't really find the right configuration. Is there any way to do this ? Thanks and regards. Christophe. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: command is not allowed with this MySQL version
- Original Message - From: Christophe t...@stuxnet.org Subject: command is not allowed with this MySQL version 'The used command is not allowed with this MySQL version' Out of sheer morbid curiosity, what version were they running? -- Unhappiness is discouraged and will be corrected with kitten pictures. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: command is not allowed with this MySQL version
Hi, Christophe has already told, The used MySQL version is 5.5.40 from Debian Wheezy package. Maybe you missed *mysql command-line client's --local-infile option* $ bin/mysql mysql SELECT @@version; ++ | @@version | ++ | 5.5.40-log | ++ 1 row in set (0.00 sec) mysql SELECT @@local_infile; ++ | @@local_infile | ++ | 1 | ++ 1 row in set (0.00 sec) mysql LOAD DATA LOCAL INFILE '/files/tmp_import.csv' INTO TABLE users FIELDS TERMINATED BY ';' LINES TERMINATED BY '\n' IGNORE 1 LINES (@dummy, nom, prenom, @dummy, @dummy, email, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy,@dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy); ERROR 1148 (42000): The used command is not allowed with this MySQL version $ bin/mysql --local-infile mysql LOAD DATA LOCAL INFILE '/files/tmp_import.csv' INTO TABLE users FIELDS TERMINATED BY ';' LINES TERMINATED BY '\n' IGNORE 1 LINES (@dummy, nom, prenom, @dummy, @dummy, email, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy,@dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy); ERROR 1146 (42S02): Table 'd1.users' doesn't exist Would you try it? yoku0825, 2014-12-12 11:00 GMT+09:00 Johan De Meersman vegiv...@tuxera.be: - Original Message - From: Christophe t...@stuxnet.org Subject: command is not allowed with this MySQL version 'The used command is not allowed with this MySQL version' Out of sheer morbid curiosity, what version were they running? -- Unhappiness is discouraged and will be corrected with kitten pictures. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
LOAD DATA LOCAL: The used command is not allowed with this MySQL version
Hi mysql-community! I have a problem with mysql 3.23.49a: If I try to use the statement 'LOAD DATA LOCAL INFILE '/storage/hosting/uxclients/www.xxx.ch/transfer/golfclub.csv' INTO TABLE test' mysql replys: 'The used command is not allowed with this MySQL version'. Why this error-message? Was LOAD DATA LOCAL not supported with 3.23? I read, that LOAD DATA LOCAL was added with 3.22.6 Do you have an idea? Thank you, Martin
Re: LOAD DATA LOCAL: The used command is not allowed with this MySQL version
Hi. See http://dev.mysql.com/doc/mysql/en/LOAD_DATA_LOCAL.html Martin Rytz [EMAIL PROTECTED] wrote: -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [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 4.0.12 -max-nt Error 1148: Used command is not allowed with this MySQL Version
I am trying to load a table from a test delimited file. This worked in the previous version. Any advice on how to accomplish this? D. H. Craig, CSM Have a grateful day! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL 4.0.12 -max-nt Error 1148: Used command is not allowed with this MySQL Version
I am trying to load a table from a test delimited file. This worked in the previous version. Any advice on how to accomplish this? D. H. Craig, CSM Have a grateful day! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] D. H. Craig, CSM Have a grateful day! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL 4.0.12 -max-nt Error 1148: Used command is not allowed with this MySQL Version
Try sqlimport (it is in the bin directory) Martin - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, April 02, 2003 4:33 PM Subject: MySQL 4.0.12 -max-nt Error 1148: Used command is not allowed with this MySQL Version I am trying to load a table from a test delimited file. This worked in the previous version. Any advice on how to accomplish this? D. H. Craig, CSM Have a grateful day! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] D. H. Craig, CSM Have a grateful day! -- 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]
JDBC and LOAD DATA LOCAL INFILE : The used command is not allowed with this MySQL version
Hello, I'm using this command into a Java servlet LOAD DATA LOCAL INFILE \ + FIC_DB + \ REPLACE INTO TABLE news; It runs well with mysql-3.23.45 but not with mysql-3.23.55 The error message is : java.sql.SQLException: General error: The used command is not allowed with this MySQL version at org.gjt.mm.mysql.MysqlIO.sendCommand(MysqlIO.java:497) at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(MysqlIO.java:550) at org.gjt.mm.mysql.MysqlIO.sqlQuery(MysqlIO.java:635) at org.gjt.mm.mysql.Connection.execSQL(Connection.java:882) at org.gjt.mm.mysql.Connection.execSQL(Connection.java:815) at org.gjt.mm.mysql.Statement.executeQuery(Statement.java:169) at org.gjt.mm.mysql.jdbc2.Statement.executeQuery(Statement.java:78) ... I compiled mysql-3.23.55 with the option --enable-local-infile and runs it with the argument! --local-i nfile=1. If I use the mysql client, it runs but not inside my Java servlet. Could you help me to find a solution ? Thank you Cédric. - 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
Error 1148 The error used Command is not allowed with this MySQL-Version
Hello, I downloded MySQL-Version 3.23 for Windows XP from MySQL-webpage. If I try to load a Database from a textfile I got message Error 1148 The error used Command is not allowed with this MySQL-Version. I used following Command: LOAD DATA LOCAL INFILE verlagdaten.txt INTO TABLE verlag; Any ideas for help? Best regards, Klaus Wagner - 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: Error 1148 The error used Command is not allowed with this MySQL-Version
Greetings I think the path for the file is not correct. Try giving the complete path with (\) in the directory name changed to (/). Also specify the escaping characters properly. For more information you can check out the MySQL docs on LOAD LOCAL INFILE. Rgds Insane SQLyog - The Definitive Windows GUI for MySQL http://www.webyog.com/sqlyog/download.html - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, November 20, 2002 5:57 PM Subject: Error 1148 The error used Command is not allowed with this MySQL-Version Hello, I downloded MySQL-Version 3.23 for Windows XP from MySQL-webpage. If I try to load a Database from a textfile I got message Error 1148 The error used Command is not allowed with this MySQL-Version. I used following Command: LOAD DATA LOCAL INFILE verlagdaten.txt INTO TABLE verlag; Any ideas for help? Best regards, Klaus Wagner - 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 - 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: Error 1148 The error used Command is not allowed with this MySQL -Version
Use the mysqlc.exe client instead of mysql.exe -- Geoff Morris -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 20, 2002 7:28 AM To: [EMAIL PROTECTED] Subject: Error 1148 The error used Command is not allowed with this MySQL -Version Hello, I downloded MySQL-Version 3.23 for Windows XP from MySQL-webpage. If I try to load a Database from a textfile I got message Error 1148 The error used Command is not allowed with this MySQL-Version. I used following Command: LOAD DATA LOCAL INFILE verlagdaten.txt INTO TABLE verlag; Any ideas for help? Best regards, Klaus Wagner - 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: Error 1148: The used command is not allowed with this MySQL version
Jeffrey, Sunday, July 28, 2002, 8:14:43 PM, you wrote: JAK Could you help me understand how to correct this error: JAK Error 1148: The used command is not allowed with this MySQL version JAK I have looked in the online manual under this section for help: JAK 4.2.4 Security issues with LOAD DATA LOCAL JAK Unfortunately I am very new to MySQL and don't have a clue as to how fix this error. I am using Windows. I think I need to modify the My.ini file under the mysqld section... I think it JAK should read local-infile=1. However when I try that, it still get this error when calling LOAD LOCAL FILE from a client application. Yes, I did start and stop the server. LOAD DATA LOCAL must be enabled in the client side, too. Put in [mysql] section on my.ini entry local-infile=1. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [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
Error 1148: The used command is not allowed with this MySQL version
Dear Support, Could you help me understand how to correct this error: Error 1148: The used command is not allowed with this MySQL version I have looked in the online manual under this section for help: 4.2.4 Security issues with LOAD DATA LOCAL Unfortunately I am very new to MySQL and don't have a clue as to how fix this error. I am using Windows. I think I need to modify the My.ini file under the mysqld section... I think it should read local-infile=1. However when I try that, it still get this error when calling LOAD LOCAL FILE from a client application. Yes, I did start and stop the server. Please help! Wishing you the best, Jeffrey Kirby (608) 743-2117 [EMAIL PROTECTED] http://www.desktopemailblaster.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