PhpMyAdmin

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

by

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

by

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