Error "1146 table 'phpmyadmin.pma__tracking doesn’t exist"

Question

This error prevents me from creating new tables and accessing the already created ones:

Error:

1146 table 'phpmyadmin.pma__tracking doesn’t exist

How do I fix this?

Answer 1

pma__tracking is a table of use of phpMyAdmin.

You probably deleted it by mistake.

To restore this table, it is possible to import this file which has all the tables (which is what the phpMyAdmin does in the installation). Or you can just run only the query down at the base phpmyadmin:

CREATE TABLE IF NOT EXISTS `pma__tracking` (
`db_name` varchar(64) NOT NULL,
`table_name` varchar(64) NOT NULL,
`version` int(10) unsigned NOT NULL,
`date_created` datetime NOT NULL,
`date_updated` datetime NOT NULL,
`schema_snapshot` text NOT NULL,
`schema_sql` text,
`data_sql` longtext,
`tracking` set('UPDATE','REPLACE','INSERT','DELETE','TRUNCATE','CREATE DATABASE','ALTER DATABASE','DROP DATABASE','CREATE TABLE','ALTER TABLE','RENAME TABLE','DROP TABLE','CREATE INDEX','DROP INDEX','CREATE VIEW','ALTER VIEW','DROP VIEW') default NULL,
`tracking_active` int(1) unsigned NOT NULL default '1',
PRIMARY KEY  (`db_name`,`table_name`,`version`)
)
COMMENT='Database changes tracking for phpMyAdmin'
DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

Answer 2

This informs that the pma__tracking table does not exist in the phpmyadmin database so go to your database administrator which in the case seems to be phpmyadmin and check the correct name of the table and database if it does not exist create them.