作者:大帅哥石头2011 | 来源:互联网 | 2023-06-01 15:47
HavingaproblemopeninganyofmydatabasesinphpMyadminItrieddeletingalotofold,irrelevant
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
在phpMyadmin中打开我的数据库时,我尝试删除许多旧的、不相关的数据库,可能在这个过程中删除了一些我不应该删除的东西,并且想知道我能做些什么来解决这个错误。
#1146 - Table 'phpmyadmin.pma__tracking' doesn't exist
# 1146 -表的phpmyadmin。pma__tracking”根本不存在
4 个解决方案
17
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:
所有phpMyAdmin表都是在SQL /create_tables.sql中附带的SQL转储中定义的。您可以将该文件导入到它的全部(也将重新创建您可能已经删除的其他表),或者通过运行这个查询创建丢失的表:
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;
Switch to the phpmyadmin database. You can then use the "SQL" tab to execute this query directly on the database.
切换到phpmyadmin数据库。然后可以使用“SQL”选项卡直接在数据库上执行这个查询。