#1146-表'phpmyadmin.pma__tracking'不存在 [英] #1146 - Table 'phpmyadmin.pma__tracking' doesn't exist

问题描述

在phpMyadmin中打开我的任何数据库时遇到问题 我尝试删除许多旧的，不相关的数据库，并且可能在此过程中 删除了我不应该拥有的内容，并且想知道如何解决该错误

Having a problem opening any of my databases in phpMyadmin I tried deleting a lot of old, irrelevant databases and may have in the process deleted something I shouldn't have and was wondering what I could do to resolve the error

#1146-表'phpmyadmin.pma__tracking'不存在

#1146 - Table 'phpmyadmin.pma__tracking' doesn't exist

推荐答案

所有phpMyAdmin表均在

All the phpMyAdmin tables are defined in the SQL dump that comes with the package in sql/create_tables.sql. You can import that file in it's entirety (will also re-create any other tables you might have dropped) or just create the missing table by running this query:

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;

切换到phpmyadmin数据库.然后，您可以使用"SQL"标签直接在数据库上执行此查询.

Switch to the phpmyadmin database. You can then use the "SQL" tab to execute this query directly on the database.

这篇关于#1146-表'phpmyadmin.pma__tracking'不存在的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！