- 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
Normally, upgrading is just a matter of installing the newer version into a separate directory and copying the previous version's config.inc.php to the new directory.
Note
An upgrade path or the first-installation path, which should not be taken, is to copy libraries/config.default.php to config.inc.php. This is because the default configuration file is version-specific, and is not guaranteed to work for the future versions.
New parameters appear from version to version. They are documented in Documentation.html and defined in libraries/config.default.php. If a configuration parameter is not present in config.inc.php, its value from libraries/config.default.php will be used. Therefore, we do not have to include it in config.inc.php if the default value suits us.
Special care must be taken to propagate the changes we might have made to the layout.inc.php files depending on the themes used. We will have to copy our custom themes sub-directories if we added our own themes to the structure.
-
No Comment