Article ID: 119877, created on Jan 29, 2014, last review on May 11, 2014

  • Applies to:
  • Plesk 11.5 for Windows


Export of large Mysql database (for example, 200 MB or higher) does not work, when memory usage exceeds memory_limit value in Plesk php config file (%plesk_dir%\admin\php.ini). You may get the following error:

  1. 500 Internal server error in browser.

  2. In php error log:

    PHP Fatal error:  Out of memory (allocated 278134784) (tried to allocate 268173312 bytes) in C:\Program Files (x86)\Parallels\Plesk\admin\htdocs\domains\databases\phpMyAdmin\export.php on line 202


Limitation of database size in PHPMyadmin. More information can be found here:


1) Use native mysql command line utlity to create backup of database:

    C:\Program Files (x86)\Parallels\Plesk\Databases\MySQL51\bin\mysqldump -uadmin -p"*****" -P3306 database> dump_of_database.txt

Where database is name of database, dump_of_database.txt is file where you would like to export database. ** is the password for Mysql admin user.

2) Change php limits and|or use gzip archiving on the fly. For that correct config.default.php, usually it is located in C:\Program Files (x86)\Parallels\Plesk\admin\htdocs\domains\databases\phpMyAdmin\libraries\config.default.php. Change string:

    >>$cfg['Export']['compression'] = 'none';


    >>$cfg['Export']['compression'] = 'gzip';

Search Words

phpMyAdmin Out of memory

a914db3fdc7a53ddcfd1b2db8f5a1b9c 56797cefb1efc9130f7c48a7d1db0f0c 46a8e394d6fa13134808921036a34da8 85a92ca67f2200d36506862eaa6ed6b8 bd7fc88cf1b01f097749ae6f87272128

Email subscription for changes to this article
Save as PDF