Import Failed. The used command is not allowed with this MySQL version

X

xsname

Verified User
Joined
Oct 20, 2013
Messages
6
Hi,

I am trying to import a csv file into my wordpress site. But after submitting the file I get following error on screen with no import.


Code: 
Import Failed

The used command is not allowed with this MySQL version

I searched and found http://dev.mysql.com/doc/refman/5.5/en/load-data-local.html but it didn't helped me. How can I resolve this issue ?

PS: I implemented my-large.cnf file on mysql

Thank You
 
So you may need to check MySQL logs, as far as i read should not also be realted to MySQL Version but to a privilege missing.

Regards
 
SeLLeRoNe said:
So you may need to check MySQL logs, as far as i read should not also be realted to MySQL Version but to a privilege missing.

Regards
Click to expand...

This is not related to mysql version but configuration. I tried their mentioned fix already but no luck. On cPanel servers I never face such problem.


Thank You
 
Are you sure your using mysql 5.5? My guess is your wordpress plugin is outdated. Do you know what command its attempting to issue?
 
scsi said:
Are you sure your using mysql 5.5? My guess is your wordpress plugin is outdated. Do you know what command its attempting to issue?
Click to expand...

I am using MySQL 5.6. Wordpress plugin is up-to-dated. I am using same plugin on a cpanel box with MySQL 5.5 without any trouble.
 
Maybe...
check if you have 'local-infile=0' in your my.cnf.
If so, comment it, restart your mysqld daemon and try to import the file again.
Don't forget to change it back if you don't need it anymore.
 
You must log in or register to reply here.
Back
Top