Invalid query: The used command is not allowed with this MyS

Posted: Mon Sep 05, 2011 8:37 am

Invalid query: The used command is not allowed with this MySQL version114/home/content

MySql is not setup for "LOAD DATA LOCAL INFILE" to work. I use this MySql statement because it takes just a few seconds to insert the 10 mb data feed into MySql.

It was stated to Ensure that this is in the server my.ini file:
(trying to using the php5.ini file instead)

[mysqld]
local-infile=1

[mysql]
local-infile=1

Still getting the error first mentioned

Posted: Wed Sep 07, 2011 4:05 am

@ bobbyg - not sure what this has to do with this topic?

[Moved by Raven 9/7/2011]

Posted: Wed Sep 07, 2011 3:29 pm

Did not find another that dealt with it but since this topic covered php 5, php.ini and Go Daddy I placed it here. I am still getting the invalid query and thought maybe someone could suggest an alternative. I do not have access to the source, so I have to fix via php5.ini.

Posted: Wed Sep 07, 2011 9:40 pm

Don't know if this will help you at all...

http://search.cpan.org/~ctbrown/MySQL-Slurp-0.28/lib/MySQL/Slurp.pm

Also, if I'm understanding your post correctly... here is what I found on the mysql website as the last comment on this subject found here: http://dev.mysql.com/doc/refman/5.0/en/load-data-local.html

Quote:

I found this solution on another site.. in case the thread gets deleted I'll copy & paste it below.. Here is the original link:
http://forums.westhost.com/showthread.php?t=7010#6

edit my.cnf in /etc/:
----------------------------------------
[mysqld]
...(other stuff)
local-infile=1
[mysql]
...(other stuff)
local-infile=1

then shutdown, then start mysql:
----------------------------------------
shell> mysqladmin shutdown
shell> cd /usr/libexec
shell> mysqld

This would mean you need complete access to your server in order to make changes to the server itself.

Posted: Thu Sep 08, 2011 1:13 am

bobbyg wrote:

Invalid query: The used command is not allowed with this MySQL version114/home/content

Ah, that indicates a MySQL version of 5.1.14 and I think LOAD DATA LOCAL INFILE only works in 5.1.17 (though of course I could be wrong) - something worth checking though.

Posted: Thu Sep 08, 2011 12:02 pm

Thanks, the Go Daddy support group responded with using php5.ini to override my.ini. I thought this was wrong, but then again, since I don't have direct access to the server I had no way to check out.

Posted: Thu Sep 08, 2011 1:13 pm

Finally received an answer that made sense from Go Daddy. I will have to move over to a virtual dedicated or a dedicated server and then I can have the mysql set up as I need it.