Symptoms
Export/import of database via phpMyAdmin fails with Internal Server Error:
Error in Processing Request
Error code: 500
Error text: Internal Server Error
Other memory consuming actions can also lead to such error.
The following error can be found in the /var/log/httpd/error_log file on phpMyAdmin server:
[Wed Feb 12 21:01:12 2014] [error] [client 192.168.10.10] PHP Fatal error: Allowed memory size of 25165824 bytes exhausted (tried to allocate 12287528 bytes) in /usr/local/pem/sysvhosts/phpMyAdmin/libraries/zip.lib.php on line 114, referer:
or:
PHP Fatal error: Allowed memory size of 25165824 bytes exhausted (tried to allocate 71 bytes) in /usr/local/pem/sysvhosts/phpMyAdmin4/libraries/tcpdf/unicode_data.php on line 10951
Cause
PHP memory limit is low on the side of phpMyAdmin server.
# grep memory_limit /usr/libexec/php4-cgi/etc/php.ini
memory_limit = 24M
In case of LSH NG the path is:
# grep 'memory_limit' /var/www/cgi-bin/sw-engine/php.ini
memory_limit = 24M
Resolution
Increase PHP memory_limit on the server where phpMyAdmin service is enabled.