Mastering phpMyAdmin 3.4 for Effective MySQL Management

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 ...