Mastering phpMyAdmin 3.3.x for Effective MySQL Management
Marc Delisle更新时间：2021-04-13 17:03:28
最新章节：Index封面
版权页
Credits
About the Author
About the Reviewers
Preface
What you need for this book
Who this book is for
Conventions
Reader feedback
Customer support
Chapter 1. Getting Started with phpMyAdmin
Installing phpMyAdmin
Configuring phpMyAdmin
Upgrading phpMyAdmin
Summary
Chapter 2. Configuring Authentication and Security
Securing phpMyAdmin
Summary
Chapter 3. Over Viewing the Interface
Customizing general settings
Character sets collations and language
Navigation panel
Main panel
Query window
Summary
Chapter 4. Taking First Steps
Creating our first table
Inserting data manually
Browse mode
Creating an additional table
Summary
Chapter 5. Changing Data and Structure
Changing a table's structure
Summary
Chapter 6. Exporting Structure and Data (Backup)
Exporting a database
Exporting a table
Exporting selectively
Exporting multiple databases
Saving the export file on the server
Memory limits
Summary
Chapter 7. Importing Structure and Data
Importing SQL files
Importing CSV files
Importing other formats
Reading files from a web server upload directory
Displaying an upload progress bar
Displaying a character set dialog
Summary
Chapter 8. Searching Data
Single-table searches
Performing a complete database search
Summary
Chapter 9. Performing Table and Database Operations
Changing table attributes
Renaming moving and copying tables
Multi-table operations
Database operations
Summary
Chapter 10. Benefiting from the Relational System
Linked-tables infrastructure
Defining relations with the relation view
Defining relations with the Designer
Benefiting from the defined relations
Column-commenting
Summary
Chapter 11. Entering SQL Commands
The Query window
Multi-statement queries
Pretty printing (syntax-highlighting)
The SQL Validator
Summary
Chapter 12. Generating Multi-table Queries
Exploring column criteria
Generating automatic joins
Executing the query
Summary
Chapter 13. Synchronizing Data and Supporting Replication
Supporting MySQL replication
Summary
Chapter 14. Using Bookmarks
Creating bookmarks
Recalling bookmarks from the bookmarks list
Bookmark parameters
Executing bookmarks by browsing the pma_bookmark table
Summary
Chapter 15. Documenting the System
Generating relational schemas in PDF
Summary
Chapter 16. Transforming Data Using MIME
Enabling transformations
Examples of transformations
Summary
Chapter 17. Supporting MySQL 5.0 and 5.1
Supporting routines—stored procedures and functions
Executing code with triggers
Using information_schema
Profiling
Partitioning
Exploring the Event Scheduler
BLOB streaming
Summary
Chapter 18. Tracking Changes
Prerequisites
Principles
Initiating tracking for one table
Testing the tracking mechanism
Determining tracking status
Structure snapshot
Exporting a version
Creating a new version
Deleting tracking information
Summary
Chapter 19. Administrating the MySQL Server with phpMyAdmin
Database information
Server information
Summary
Appendix A. The History of phpMyAdmin
Project re-launch
Evolution
GoPHP5 and the 3.x branch
Awards
Future phpMyAdmin versions
Appendix B. Troubleshooting and Support
Verifying the base configuration
Solving common errors
Seeking support
FAQs
Help forums
Contributing to the project
Index
更新时间：2021-04-13 17:03:28