Mysql Import with phpmyadmin errors – The used command is not allowed with this MySQL version

Trying to LOAD DATA with phpmyadmin

#1085 – The file ‘/tmp/phpqcXPYv’ must be in the database directory or be readable by all
#1148 – The used command is not allowed with this MySQL version


/etc/mysql/my.cnf
[mysqld]
local-infile=0

If this is set to local-infile=1 – and restart mysql – this should work
Also – if that does not work – try adding it under the [client] section

Leave a Comment

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.