phpMyAdmin shows error exporting large database: PHP Fatal error: Allowed memory size of 268435456 bytes exhausted

Created:

2016-11-16 12:52:17 UTC

Modified:

2017-08-08 13:16:04 UTC

0

Was this article helpful?


Have more questions?

Submit a request

phpMyAdmin shows error exporting large database: PHP Fatal error: Allowed memory size of 268435456 bytes exhausted

Applicable to:

  • Plesk 12.5 for Linux

Symptoms

When trying to export a database to a file using phpMyAdmin tool, it generates a file of 0 bytes in size.

Also Internet-browser may fail to find the file at https://domain.tld:8443/domains/databases/phpMyAdmin/export.php . Following error appears in /var/log/sw-cp-server/error_log :

        FastCGI-stderr: PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 98069376 bytes) in /opt/psa/admin/htdocs/domains/databases/phpMyAdmin/libraries/zip.lib.php on line 115

Resolution

  1. Open Plesk /usr/local/psa/admin/conf/php.ini file.

  2. Find memory_limit value and increase it, for example:

    memory_limit = 256M
  3. Restart psa service:

    # /etc/init.d/psa stopall
    # /etc/init.d/psa start

This issue has been fixed in Parallels Panel 10.4. Consider upgrading Parallels Panel on your server.

Have more questions? Submit a request
Please sign in to leave a comment.