Friday, May 10, 2013

phpmyadmin - Fatal error : allowed memory size of bytes exhausted

Fatal error: Allowed memory size of bytes exhausted (tried to allocate bytes)




If you are not able to open phpmyadmin because of this error, follow the steps to remove it.

1) Open file php.ini
xampp : /opt/lampp/etc/php.ini
apache2 (Debian) : /etc/php5/apache2/php.ini 
httpd (RHEL) : /etc/php.ini

2) Search parameter memory_limit. By default it's value is 128M.
    Increase the value according to size of parameters upload_max_filesize and post_max_size.
memory_limit = 512M

3) Restart Apache.

There is a instruction in php.ini that "Maximum amount of memory a script may consume (128MB)" but when you will increase the memory size greater than 128M, you will see yourself that error is gone.


NOTE :
The first things to check are the values of upload_max_filesizememory_limit and post_max_size in the php.ini configuration file. All of these three settings limit the maximum size of data that can be submitted and handled by PHP. post_max_size and memory_limit need to be equal or larger than upload_max_filesize.

Be careful to set memory_limit size. If it exceeds the limit, the phpmyadmin does not start. It shows blank page.

You have increased the memory limit but you still get this error frequently. Restart the Apache will solve your problem. If you are working on live Linux server and it does not restart frequently. You might get this error too often, make a Crontab for daily Apache-Restart will solve your problem.

No comments:

Post a Comment