Mastering phpMyAdmin 3.3.x for Effective MySQL Management. A complete guide to get started with phpMyAdmin 3.3 and master its features Marc Delisle, Software Freedom Conservancy Inc

Spis treści książki

• Mastering phpMyAdmin 3.3.x for Effective MySQL Management
  • Table of Contents
  • Mastering phpMyAdmin 3.3.x for Effective MySQL Management
  • Credits
  • About the Author
  • About the Reviewers
  • Preface
    • What this book covers
    • What you need for this book
    • Who this book is for
    • Conventions
    • Reader feedback
    • Customer support
      • Errata
      • Piracy
      • Questions
  • 1. Getting Started with phpMyAdmin
    • Introducing phpMyAdmin
      • Web applications
      • PHP and MySQL: The leading open source duo
      • What is phpMyAdmin?
        • Project documentation
    • Installing phpMyAdmin
      • Required information
      • System requirements
      • Downloading the files
      • Installing on different platforms
        • Installing on a remote server using a Windows machine
        • Installing on a local Linux server
        • Installing on local Windows servers (Apache, IIS)
    • Configuring phpMyAdmin
      • The config.inc.php file
        • Avoiding false error messages about permissions on config.inc.php
      • Configuration principles
      • Web-based setup script
      • Manually creating config.inc.php
      • Tips for editing config.inc.php on a Windows client
      • Description of some configuration parameters
        • PmaAbsoluteUri
        • Server-specific sections
          • extension
          • connect_type, socket, and port
          • compress configuration
        • PersistentConnections
    • Upgrading phpMyAdmin
    • Summary
  • 2. Configuring Authentication and Security
    • Logging in to MySQL through phpMyAdmin
      • Logging in to an account without a password
      • Authenticating a single user with config
        • Testing the MySQL connection
      • Authenticating multiple users
        • Authentication types offered
        • The control user
        • Logging out
        • Authenticating with HTTP
        • Authenticating users with cookie values
        • Authenticating through the signon mode
      • Configuring for multiple server support
        • Defining servers in the configuration file
        • Authenticating through an arbitrary server
    • Securing phpMyAdmin
      • Protecting phpMyAdmin at the directory level
      • Displaying error messages
      • Protecting with IP-based access control
        • Defining rules
        • Order of interpretation for rules
        • Blocking root access
      • Protecting in-transit data
      • Authenticating using Swekey hardware
        • Configuring Swekey authentication
        • Using phpMyAdmin in a Swekey context
        • Security note
      • Access logging
        • Available information
        • Configuring Apache
    • Summary
  • 3. Over Viewing the Interface
    • Over viewing panels and windows
      • Login panels
      • Navigation and main panels
        • Home page
        • Views
      • Query window
      • Starting page
    • Customizing general settings
      • Configuring the window title
      • Configuring icons
      • Natural sort order for database and table names
      • Creating site-specific headers and footers
      • Displaying MySQL documentation links
      • Themes
        • Configuring themes
        • Selecting themes
      • Assigning colors using the color picker
      • Sliders
      • Limiting URL lengths
      • Restricting the list of databases
    • Character sets, collations, and language
      • Collations
      • Unicode and UTF-8
      • Selecting languages
      • Effective character sets and collations
    • Navigation panel
      • Configuring the logo
      • Database and table list
        • Light mode
          • Tree display of database names
          • Table name filter
        • Full mode
        • Table short statistics
        • Table quick-access icon
        • Nested display of tables within a database
      • Choosing from the server list
      • Handling many databases or tables
        • Limits on the interface
        • Improving fetch speed
    • Main panel
      • Home page
      • Database view
      • Table view
      • Server view
      • Icons for the home page and menu tabs
      • Opening a new phpMyAdmin window
    • Query window
    • Summary
  • 4. Taking First Steps
    • Creating a database
      • No privileges?
      • First database creation is authorized
    • Creating our first table
      • Choosing the fields
      • Creating a table
      • Choosing keys
    • Inserting data manually
      • Data entry panel tuning for CHAR and VARCHAR
    • Browse mode
      • SQL query links
      • Navigation bar
      • Query results operations
      • Sorting results
        • Headwords
      • Color-marking rows
      • Limiting the length of each column
        • Display options
      • Browsing distinct values
      • Customizing the browse mode
    • Creating an additional table
    • Summary
  • 5. Changing Data and Structure
    • Changing data
      • Entering edit mode
        • Moving to the next field with the tab key
        • Moving with arrows
        • Handling NULL values
        • Applying a function to a value
        • Duplicating rows of data
      • Multi-row editing
      • Editing the next row
      • Deleting data
        • Deleting a single row
        • Deleting many rows
        • Deleting all of the rows in a table
        • Deleting all rows in many tables
      • Deleting tables
      • Deleting databases
    • Changing a tables structure
      • Adding a field
        • Vertical mode
        • Horizontal mode
      • Editing field attributes
      • TEXT fields
      • BLOB (Binary Large Object) fields
        • Uploading binary content
      • ENUM and SET fields
      • DATE, DATETIME, and TIMESTAMP fields
        • Calendar pop up
        • TIMESTAMP options
      • Bit fields
      • Managing indexes
        • Single-field indexes
        • Multi-field indexes and index editing
        • FULLTEXT indexes
        • Optimizing indexes with EXPLAIN
        • Detecting index problems
    • Summary
  • 6. Exporting Structure and Data (Backup)
    • Dumps, backups, and exports
      • Scope of the export
    • Exporting a database
      • The export subpanel
      • SQL
        • Defining options for SQL export
      • The "Save as file" subpanel
        • File name template
        • Compression
        • Choosing a character set
        • Kanji support
      • CSV
      • CSV for MS Excel
      • PDF
      • Microsoft Word 2000
      • LaTeX
      • XML
      • Open document spreadsheet
      • Open document text
      • YAML
      • CodeGen
      • Texy! text
      • PHP array
      • Excel 97-2003 and Excel 2007 Workbook
      • MediaWiki table
    • Exporting a table
      • Split-file exports
    • Exporting selectively
      • Exporting partial query results
      • Exporting and checkboxes
    • Exporting multiple databases
    • Saving the export file on the server
      • User-specific save directories
    • Memory limits
    • Summary
  • 7. Importing Structure and Data
    • Limits for the transfer
      • Time limits
      • Other limits
      • Handling big export files
      • Uploading into a temporary directory
    • Importing SQL files
    • Importing CSV files
      • Differences between SQL and CSV formats
      • Exporting a test file
      • CSV
      • CSV using LOAD DATA
        • Requirements
        • Using the LOAD DATA interface
    • Importing other formats
      • Open Document Spreadsheet
      • Excel
      • XML
    • Reading files from a web server upload directory
    • Displaying an upload progress bar
      • Configuring APC
    • Displaying a character set dialog
    • Summary
  • 8. Searching Data
    • Using Search page daily
    • Single-table searches
      • Entering the search subpage
      • Searching criteria by fieldquery by example
        • Searching for empty or non-empty values
      • Producing reports with Print view
      • Searching with wildcard characters
      • Performing a case-sensitive search
      • Combining criteria
      • Search options
        • Selecting the fields to be displayed
        • Ordering the results
        • Applying a WHERE clause
        • Avoiding repeated results
    • Performing a complete database search
      • Restricting the search to a column
      • Stopping an errant query
    • Summary
  • 9. Performing Table and Database Operations
    • Maintaining a table
    • Changing table attributes
      • Table storage engine
      • Table comments
      • Table order
      • Table collation
      • Table options
    • Renaming, moving, and copying tables
      • Appending data to a table
    • Multi-table operations
      • Repairing an "in use" table
    • Database operations
      • Renaming a database
      • Copying a database
    • Summary
  • 10. Benefiting from the Relational System
    • Relational MySQL
      • InnoDB and PBXT
    • Linked-tables infrastructure
      • Goal of the infrastructure
      • Location of the infrastructure
      • Installing the linked-tables infrastructure
        • Installing for a single user
          • Configuring the infrastructure
        • Installing for multiple users
    • Defining relations with the relation view
      • Defining internal relations
        • Defining the relation
        • Defining the display field
      • Foreign key relations
        • Foreign keys without linked-tables infrastructure
    • Defining relations with the Designer
      • Over viewing the interface
      • Defining relations
        • Defining foreign key relations
      • Defining the display field
      • Exporting for PDF schema
    • Benefiting from the defined relations
      • Foreign key information
      • The drop-down list of foreign keys
      • The browsable foreign-table window
      • Referential integrity checks
      • Automatic updates of metadata
    • Column-commenting
      • Automatically migrating column comments
    • Summary
  • 11. Entering SQL Commands
    • The SQL query box
      • The Database view
      • The Table view
        • The Fields selector
        • Clicking into the query box
    • The Query window
      • Query window options
      • Session-based SQL history
      • Database-based SQL history (permanent)
      • Editing queries in the query window
    • Multi-statement queries
    • Pretty printing (syntax-highlighting)
    • The SQL Validator
      • System requirements
      • Making the Validator available
      • Validator results
        • Standard-conforming queries
        • Non-standard-conforming queries
    • Summary
  • 12. Generating Multi-table Queries
    • Choosing tables
    • Exploring column criteria
      • Field selector: Single-column or all columns
      • Sorting columns
      • Showing a column
      • Updating the query
      • Adding conditions to the criteria box
        • Adjusting the number of criteria rows
        • Adjusting the number of criteria columns
    • Generating automatic joins
    • Executing the query
    • Summary
  • 13. Synchronizing Data and Supporting Replication
    • Synchronizing data and structure
      • Goals of synchronization
        • Moving between the development and production servers
        • Collaboration between database designers
        • Preparing for replication
      • Over viewing the synchronization process
      • Preparing for the synchronization exercise
      • Choosing source and target servers and databases
      • Analyzing comparison results
      • Performing a complete synchronization
      • Performing a selective synchronization
    • Supporting MySQL replication
      • The Replication menu
      • Configuring replication
        • Master server configuration
        • Slave server configuration
      • Setting up a test environment
      • Controlling a slave server
      • Obtaining replication information
        • Gathering replication status
        • Replicated databases
        • Replicated tables
    • Summary
  • 14. Using Bookmarks
    • Comparing bookmark and query history features
    • Creating bookmarks
      • Creating a bookmark after a successful query
      • Storing a bookmark before sending a query
      • Making bookmarks public
      • The default initial query for a table
      • Multi-query bookmarks
    • Recalling bookmarks from the bookmarks list
      • Executing bookmarks
      • Manipulating bookmarks
    • Bookmark parameters
      • Creating a parameterized bookmark
      • Passing a parameter value to a bookmark
    • Executing bookmarks by browsing the pma_bookmark table
    • Summary
  • 15. Documenting the System
    • Producing structure reports
      • Creating a printable report
      • The database print view
        • The selective database print view
      • The table print view
      • Preparing a complete report with the data dictionary
    • Generating relational schemas in PDF
      • Adding a third table to our model
      • Editing PDF pages
        • Page planning
        • Creating a new page
        • Editing a page
        • Displaying a page
        • Changing the font in PDF schema
      • Laying out a PDF schema with the Designer feature
    • Summary
  • 16. Transforming Data Using MIME
    • Browsing data without transformations
      • Switching display options
    • Enabling transformations
      • Configuring settings for MIME columns
        • Selecting the MIME type
        • Browser transformations
        • Assigning values to transformation options
      • Requirements for image generation
        • Configuring GD2 library availability verification
        • Asserting support of JPEG and PNG libraries
        • Evaluating the impact of memory limits
    • Examples of transformations
      • Clickable thumbnail (.jpeg or .png)
      • Adding links to an image
      • Date formatting
      • Links from text
        • text/plain: link
        • text/plain: imagelink
      • Preserving the original formatting
      • Displaying parts of a text
      • Displaying a download link
      • Hexadecimal representation
      • SQL pretty printing
      • IP address
      • Transforming data via external applications
        • External application example: In-cell sort
    • Summary
  • 17. Supporting MySQL 5.0 and 5.1
    • Activating support for views
      • Manually creating a view
      • Main panel and views
      • Creating a view from results
      • Renaming a view
      • Controlling row counting for improved performance
    • Supporting routinesstored procedures and functions
      • Creating a stored procedure
        • Changing the delimiter
        • Entering the procedure
      • Testing the procedure
      • Manipulating procedures and functions
      • Manually creating a function
      • Testing the function
      • Exporting stored procedures and functions
    • Executing code with triggers
      • Manually creating a trigger
      • Testing the trigger
    • Using information_schema
    • Profiling
    • Partitioning
      • Creating a table with partitions
      • Maintaining partitions
      • Exporting a partition definition
    • Exploring the Event Scheduler
      • Activating the scheduler
      • Granting EVENT permission
      • Creating an event
      • Manipulating events
      • Exporting
    • BLOB streaming
      • System requirements
      • Configuring BLOB streaming
      • Examining implementation limitations in phpMyAdmin
      • Creating the PBMS system tables
      • Preparing the table
      • Uploading to the BLOB repository
      • Streaming the data from the repository
      • Changing repository data
    • Summary
  • 18. Tracking Changes
    • Understanding the goals of the tracking system
      • Tracking in other software applications
      • Tracking in phpMyAdmin
    • Prerequisites
      • Configuring a basic tracking mechanism
    • Principles
      • Versioning
      • Taking a snapshot of the current structure
      • Understanding archiving issues
    • Initiating tracking for one table
      • Choosing the statements to be tracked
    • Testing the tracking mechanism
      • Tracking report
    • Determining tracking status
      • Deactivating and activating tracking
    • Structure snapshot
    • Exporting a version
    • Creating a new version
      • Quickly accessing tracking information
    • Deleting tracking information
    • Summary
  • 19. Administrating the MySQL Server with phpMyAdmin
    • Managing users and their privileges
      • The user overview
        • Privileges reload
      • Adding a user
        • Entering the username
        • Assigning a host value
        • Setting passwords
        • Understanding rights for database creation
        • Assigning global privileges
        • Limiting the resources used
      • Editing a user profile
        • Editing privileges
        • Assigning database-specific privileges
        • Changing the password
        • Changing login information or copying a user
      • Removing a user
    • Database information
      • Enabling statistics
      • Sorting statistics
      • Checking the database privileges
      • Dropping selected databases
    • Server information
      • Verifying server status
        • The general status page
        • InnoDB status
      • Server variables
      • Server processes
      • Storage engines
      • Available character sets and collations
      • Examining binary logs
    • Summary
  • A. The History of phpMyAdmin
    • Early events
    • Project re-launch
      • Distributors
    • Evolution
    • GoPHP5 and the 3.x branch
    • Awards
    • Future phpMyAdmin versions
  • B. Troubleshooting and Support
    • System requirements
    • Verifying the base configuration
    • Solving common errors
      • Troubleshooting error messages
        • Cannot load MySQL extension
        • #2003 - Can't connect to MySQL server
        • Socket problem (Linux/UNIX)
        • Named pipe problem (Windows)
        • MySQL said: Access denied
        • When using http authentication
        • When using http, cookie, or config authentication
        • Access denied ... "using password: NO"
        • Access denied ... "using password: YES"
        • Login without a password is forbidden by configuration
        • Warning: cannot add header information
        • MySQL said: Error 127, Table Must Be Repaired
        • BLOB column used in key specification without a key length
        • IIS: No Input File Specified
        • A "404: page not found" error when modifying a row
      • Troubleshooting other problems
        • Blank page or weird characters
        • Not being able to create a database
        • Problems importing large files or uploading large BLOB files
        • MySQL root password lost
        • Duplicate field names when creating a table
        • Authentication window displayed more than once
        • Column size changed by phpMyAdmin
        • Seeing many databases that are not ours
        • Not being able to store a value greater than 127
    • Seeking support
    • FAQs
    • Help forums
      • Creating a SourceForge account
      • Choosing the thread title
      • Reading the answers
      • Using the support tracker
      • Using the bug tracker
      • Environment description
      • Bug description
    • Contributing to the project
      • The code base
      • Translation updates
      • Patches
  • Index

pokaż cały spis treści

ukryj recenzje