Prev | Current Page 163 | Next

Marc Delisle

"Mastering phpMyAdmin 2.11 for Effective MySQL Management"

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.


Pages:
151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175