Load Data Local – Disabled

[malik]

HI

I have just moved servers and found that LOAD DATA LOCAL is disabled on the new server.

This means i can no longer use sqlyog to import using – Import CSV data using load local.

I looked at import external data option but this appears more for scheduling/wizard whereas i want to do a simple manual import.

Are there any other options for loading csv data to the DB using sqlyog?

Thanks

[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