Mastering phpMyAdmin 2.11 for Effective MySQL Management

Book Image

Mastering phpMyAdmin 2.11 for Effective MySQL Management

Book Image

Mastering phpMyAdmin 2.11 for Effective MySQL Management

Overview of this book

Mastering phpMyAdmin 2.11 for Effective MySQL Management

Mastering phpMyAdmin 2.11 for Effective MySQL Management

Credits

About the Author

About the Author

About the Reviewers

About the Reviewers

Preface

Free Chapter

Introducing phpMyAdmin

Introducing phpMyAdmin

PHP and MySQL: The Leading Open-Source Duo

What is phpMyAdmin?

phpMyAdmin Features Summary

Installing phpMyAdmin

Installing phpMyAdmin

System Requirements

Downloading the Files

First Connection Configuration

Multi-Server Configuration

Advanced Authentication

Upgrading phpMyAdmin

Interface Overview

Interface Overview

Panels and Windows

Language Selection

Site-Specific Header and Footer

MySQL Documentation Links

First Steps

Database Creation

Creating Our First Table

Manual Data Insertion

Creating an Additional Table

Changing Data

Multi-Row Editing

Editing the Next Row

Deleting Tables

Deleting Databases

Changing Table Structures

Changing Table Structures

Editing Field Attributes

BLOB (Binary Large Object) Fields

DATE, DATETIME, and TIMESTAMP

Index Management

Exporting Structure and Data

Exporting Structure and Data

Dumps, Backups, and Exports

Database Exports

Selective Exports

Multi-Database Exports

Saving the Export File on the Server

Importing Structure and Data

Importing Structure and Data

Limits for the Transfer

Importing SQL Files

Importing CSV Files

Web Server Upload Directories

Searching Data

Single-Table Searches

Complete Database Search

Table and Database Operations

Table and Database Operations

Table Maintenance

Changing Table Attributes

Renaming, Moving, and Copying Tables

Multi-Table Operations

Database Operations

The Relational System

The Relational System

Relational MySQL?

Linked-Tables Infrastructure

Defining Relations with the Relation View

Defining Relations with the Designer

Benefits of the Defined Relations

Column-Commenting

Entering SQL Commands

Entering SQL Commands

The SQL Query Box

The Query Window

Multi-Statement Queries

Pretty Printing (Syntax-Highlighting)

The SQL Validator

The Multi-Table Query Generator

The Multi-Table Query Generator

Choosing Tables

Column Criteria

Automatic Joins

Executing the Query

Bookmarks

Creating a Bookmark after a Successful Query

Storing a Bookmark before Sending a Query

Multi-Query Bookmarks

Recalling from the Bookmarks List

Public Bookmarks

The Default Initial Query for a Table

Bookmark Parameters

Executing Bookmarks by Browsing the pma_bookmark Table

System Documentation

System Documentation

The Database Print View

The Selective Database Print View

The Table Print View

The Data Dictionary

Relational Schema in PDF

MIME-Based Transformations

MIME-Based Transformations

The MIME Column's Settings

Requirements for Image Generation

Examples of Transformations

Character Sets and Collations

Character Sets and Collations

Language Files and UTF-8

Versions of MySQL Prior to 4.1.x

MySQL 4.1.x and Later

MySQL 5.0 Features

MySQL 5.0 Features

Observations on the History of MySQL 5.0

Routines: Stored Procedures and Functions

Information_schema

MySQL Server Administration

MySQL Server Administration

Entering the Server View

Database Information

Server Operations

Troubleshooting and Support

Troubleshooting and Support

System Requirements

Base Configuration

Solving Common Errors

Seeking Support

Contributing to the Project

Future phpMyAdmin Versions

Customer Reviews

5 star

0

4 star

0

3 star

0

2 star

0

1 star

0

Language Selection

A Language selector appears on the login panel (if any) and on the Home page. The default behavior of phpMyAdmin is to use the language defined in our browser's preferences, if there is a corresponding language file for this version.

The default language used in case the program cannot detect one is defined in config.inc.php in the $cfg['DefaultLang'] parameter with'en-iso-8859-1'. This value can be changed. The possible values for language names are defined in the libraries/select_lang.lib.php script as an array.

Even if the default language is defined, each user (especially on a multi-user installation) can choose his or her preferred language from the selector:

The user's choice will be remembered in a cookie whenever possible.

We can also force a single language by setting the $cfg['Lang'] parameter with a value, such as 'en-iso-8859-1'. Starting with version 2.7.0, another parameter, $cfg['FilterLanguages'], is available. Suppose we want to shorten the list...