Database ServerLinuxMySQL

Import error: The used command is not allowed with this MySQL version

mysql logoIf you are getting Mysql Error: #42000

Import error: The used command is not allowed with this MySQL version

Such type of error generally occurs when you are trying to import data from a file into MySQL using LOAD DATA LOCAL INFILE.

To solve this problem, you will have to make changes in the my.cnf file on the server. It is generally located at /etc in Linux.

# vi /etc/my.cnf

  • Search for line local-infile
  • If local-infile is set to 0 (zero) then change it to 1 (one) i.e enable LOAD DATA LOCAL INFILE.
  • Save the file
  • Restart MySQL service

# /etc/init.d mysql restart

  • Refresh the error page

That's it.. the error is gone now !

If any feedback, queries are always welcome!

Abhijit Sandhan

Love to Automate, Blog, Travel, Hike & spread Knowledge!

Related Articles

2 Comments

Leave a Reply to Abby Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back to top button