Load Data Local – Disabled

[peterlaursen]

If the option is disabled in server configuration and you don't have privilege to change configuration you cannot LOAD DATA LOCAL (obviously).

You can still do a manul import with the 'import external data' tool. In last step of the wizard just select to execute at once (and don't schedule).

[malik]

How can i double check that 'load data' is definately disabled on the server?. The error message i am getting is:

“The used command is not allowed with this MySQL version”

[peterlaursen]

Simply execute this SQL query:

“SHOW VARIABLES LIKE 'local_infile';”

— does it return ON or OFF?

MySQL documentation:

https://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html#sysvar_local_infile

And if documentation is credible “Dynamic Variable = Yes” means that a user with SUPER privilege can change the setting online (“SET @@global.local_infile = ON;”)

[peterlaursen]

The SET statement works as expected.

But it requires SUPER privilege (http://dev.mysql.com/doc/refman/5.1/en/privileges-provided.html#priv_super).

[Author]

Posts