Prerequisites

The phpMyAdmin configuration storage holds all metadata for the tracking mechanism. If we have implemented this storage a while ago (for a previous phpMyAdmin version, such as 3.1 or older), we can use scripts/create_tables.sql from the current phpMyAdmin version to upgrade the configuration storage with the missing tables (in our case, the pma_tracking table). The reason for this is that the script creates this table in a prudent way by using the CREATE TABLE IF NOT EXISTS `pma_tracking` statement, thus ensuring that it won't be created if the table is already present.

Note

In phpMyAdmin 3.3.3, the type of the data_sql column in pma_tracking was changed from TEXT to LONGTEXT in the create_tables.sql script. Therefore, it's important to make this change manually in our own pma_tracking table, if we ran this script prior to version 3.3.3.

Configuring a basic tracking mechanism

In config.inc.php, for a specific MySQL server's configuration, the $cfg['Servers'][$i]['tracking'] should...