Memory limits

Generating an export file uses a certain amount of memory, depending on the size of the tables and on the chosen options. The $cfg['MemoryLimit'] parameter can contain a limit (in bytes) for the amount of memory used by PHP scripts in phpMyAdmin—the exporting/importing scripts and other scripts. By default, the parameter is set to 0, meaning that there is no limit. We could set here a limit of 20 MiB by using a value of 20M (the M suffix here is very important, to avoid setting a limit of 20 bytes!).

Note

Note that, if PHP has its safe mode activated, changing $cfg['MemoryLimit'] has no effect. Instead, the enforced limit comes from the memory_limit directive in php.ini.

In addition to memory limits, the execution time limit has an effect on exporting and can be controlled via the $cfg['ExecTimeLimit'] parameter.