- Mastering phpMyAdmin 3.4 for Effective MySQL Management
- Mastering phpMyAdmin 3.4 for Effective MySQL Management
- Credits
- About the Author
- About the Reviewers
- www.PacktPub.com
- Preface
- 1. Getting Started with phpMyAdmin
- PHP and MySQL: The leading open source duo
- What is phpMyAdmin?
- Installing phpMyAdmin
- Configuring phpMyAdmin
- Installing phpMyAdmin configuration storage
- Upgrading phpMyAdmin
- Summary
- 2. Configuring Authentication and Security
- 3. Over Viewing the Interface
- 4. Creating and Browsing Tables
- 5. Changing Data and Structure
- Changing data
- Changing table structure
- Summary
- 6. Exporting Structure and Data (Backup)
- 7. Importing Structure and Data
- 8. Searching Data
- 9. Performing Table and Database Operations
- 10. Benefiting from the Relational System
- 11. Entering SQL Statements
- 12. Generating Multi-table Queries
- 13. Synchronizing Data and Supporting Replication
- Synchronizing data and structure
- Supporting MySQL replication
- Summary
- 14. Using Query Bookmarks
- 15. Documenting the System
- 16. Transforming Data using MIME
- Browsing data without transformations
- Enabling transformations
- Examples of transformations
- Summary
- 17. Supporting Features Added in MySQL 5
- 18. Tracking Changes
- 19. Administrating the MySQL Server
- A. Troubleshooting and Support
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.
-
No Comment