The Relational System - Mastering phpMyAdmin 2.11 for Effective MySQL Management - page 169

It is now time to adjust all the relational-features related parameters in
config.inc.php . Here we use the default values mentioned in the comments inside
the file; these database and table names are the ones that have just been created:

$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
$cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';
$cfg['Servers'][$i]['relation'] = 'pma_relation';
$cfg['Servers'][$i]['table_info'] = 'pma_table_info';
$cfg['Servers'][$i]['table_coords'] = 'pma_table_coords';
$cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages';
$cfg['Servers'][$i]['column_info'] = 'pma_column_info';
$cfg['Servers'][$i]['history'] = 'pma_history';
$cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords';

As table names are case sensitive, we must use the same names as the
tables created by the installation script. We are free to change the table
names (see the right-hand part of the configuration directives listed)
provided we change them accordingly in the database.

Each database or table has a specific function:

pmadb : Defines which database all the tables are located in.
bookmarktable : Contains the bookmarks (explained in Chapter 14).
relation : Defines inter-table relations, as used in many of
phpMyAdmin's features.
table_info : Contains the display field (explained later in this chapter).
table_coords and pdf_pages : Contain the metadata necessary for drawing
a schema of the relations in PDF format (explained in Chapter 15).
column_info : Used for column-commenting and MIME-based
transformations (explained in Chapter 16).
history : Contains SQL query history information (explained in Chapter 12).
designer_coords : holds the coordinates used by the Designer feature
(explained later in this chapter).

•
•
•

•
•

•

•
•

Between each phpMyAdmin version, the infrastructure may be enhanced. (The
changes are explained in Documentation.html .) This is why phpMyAdmin has
various checks to ascertain the structure of tables. If we know that we are using the
latest structure, $cfg['Servers'][$i]['verbose_check'] can be set to FALSE to
avoid checks, thereby slightly increasing phpMyAdmin's speed.

The installation is now complete; we will test the features in the coming sections and
chapters. We can do a quick check by going back to the Home page: the warning
message should be gone.