Solving the Mysteries of Geek Code
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
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