This error prevents me from creating new tables and accessing those already created:
Error:
1146 table 'phpmyadmin.pma__tracking does not exist
How do I fix this?
This error prevents me from creating new tables and accessing those already created:
Error:
1146 table 'phpmyadmin.pma__tracking does not exist
How do I fix this?
pma__tracking
is a usage table for phpMyAdmin .
You probably deleted it by mistake.
To restore this table, you can import this file that has all the tables (which is what phpMyAdmin does in the installation). Or you can only just run query
down on 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;
This informs that the pma__tracking table does not exist in the phpmyadmin database so go to your database admin that in this case appears to be phpmyadmin and check the correct table and database name if it does not exist create them.