PhpMyAdmin – geekdecoder

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

August 22, 2015March 31, 2015 by The Geek Decoder

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

Database Upload Error Cpanel PhpMyAdmin

August 22, 2015March 24, 2014 by The Geek Decoder

Editing the global php.ini at /usr/local/lib/php.ini does not increase values in the internal PHP for cPanel for PhpMyAdmin.

You have to edit the internal php.ini, which apparently it is reading from /usr/locafile.rather than /usr/local/cpanel/3rdparty/etc/phpmyadmin/php.ini file.

nano /usr/local/cpanel/3rdparty/etc/phpmyadmin/php.ini
; Maximum size of POST data that PHP will accept.
post_max_size = 50M
upload_max_size = 50M