-
Book Overview & Buying
-
Table Of Contents
Mastering phpMyAdmin 2.11 for Effective MySQL Management - Third Edition
In the previous chapters, we dealt mostly with table fields. In this chapter, we will learn how to perform some operations that influence tables or databases as a whole. We will cover table attributes and how to modify them, and also discuss multi-table operations.
Various links that enable table operations have been put together on one sub-page of the Table view: Operations. Here is an overview of this sub-page:

During the lifetime of a table, it repeatedly gets modified, and so grows and shrinks. Outages may occur on the server, leaving some tables in a damaged state.
Using the Operations sub-page, we can perform various operations, but not every operation is available for every table type:
Check table: Scans all rows to verify that deleted links are correct. Also, a checksum is calculated to verify the integrity of the keys; we should get an 'OK' message if everything is all right.
Analyze table: Analyzes and stores the key...
Change the font size
Change margin width
Change background colour