Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
- Create BookmarkCreate Bookmark
- Create Note or TagCreate Note or Tag
- DownloadDownload
- PrintPrint
Chapter 6. Exporting Structure and Data (Backup) > Memory limits
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 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.
