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

user3603183

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 - Table 'phpmyadmin.pma__tracking' doesn't exist

Oldskool

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;

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

本文收集自互联网,转载请注明来源。

如有侵权,请联系[email protected] 删除。

编辑于
0

我来说两句

0条评论
登录后参与评论

相关文章

来自分类Dev

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

来自分类Dev

Protocol doesn't support the "===" operator?

来自分类Dev

Select ONE random row from Table1 where id does not exist in Table2

来自分类Dev

Android, setReuseAddress doesn't work

来自分类Dev

How to get perforce to pull only files that don't exist in workspace

来自分类Dev

Getting Table doesn't exist error, but the table does exist (ActiveRecord::StatementInvalid Mysql2::Error: Table doesn't exist)

来自分类Dev

PMA数据库...在phpMyAdmin升级中不正确

来自分类Dev

SendKeys doesn't always work

来自分类Dev

SQLite: create table and add a row if the table doesn't exist

来自分类Dev

C# - Can't use the SystemParameters, "type or namespace does not exist"

来自分类Dev

MySQL错误1064和1146

来自分类Dev

Localization doesn't work for german?

来自分类Dev

phpmyadmin cannot open table's browse view

来自分类Dev

.htaccess doesn't work on xampp (windows 7)

来自分类Dev

CSS Table Cell doesn't become full width

来自分类Dev

html footer doesn't work

来自分类Dev

HttpPost addHeader doesn't work

来自分类Dev

在/usr/share/phpMyAdmin/libraries/Error.class.php中找不到phpMyAdmin类'PMA_Message'

来自分类Dev

Adwords conversion tracking doesn't work

来自分类Dev

Doesn't work EditText padding in the API 21

来自分类Dev

#1146-表'database.table'与连接不存在吗?

来自分类Dev

#1146-表'phpmyadmin.pma__tracking'不存在如何手动禁用?

来自分类Dev

Ember 1.12.0 instance initializer: deferReadiness method doesn't exist

来自分类Dev

Why doesn't django dumpdata include the django_migrations table?

来自分类Dev

Hibernate ImprovedNamingStrategy doesn't work

来自分类Dev

phpmyadmin显示错误#1064 alter table

来自分类Dev

#1146-联接中不存在表'database.table'吗?

来自分类Dev

#145-表'。\ phpmyadmin \ pma_recent'被标记为已崩溃,应进行修复

来自分类Dev

#1146-表'phpmyadmin.pma__tracking'不存在如何手动禁用?

Related 相关文章

  1. 1

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

  2. 2

    Protocol doesn't support the "===" operator?

  3. 3

    Select ONE random row from Table1 where id does not exist in Table2

  4. 4

    Android, setReuseAddress doesn't work

  5. 5

    How to get perforce to pull only files that don't exist in workspace

  6. 6

    Getting Table doesn't exist error, but the table does exist (ActiveRecord::StatementInvalid Mysql2::Error: Table doesn't exist)

  7. 7

    PMA数据库...在phpMyAdmin升级中不正确

  8. 8

    SendKeys doesn't always work

  9. 9

    SQLite: create table and add a row if the table doesn't exist

  10. 10

    C# - Can't use the SystemParameters, "type or namespace does not exist"

  11. 11

    MySQL错误1064和1146

  12. 12

    Localization doesn't work for german?

  13. 13

    phpmyadmin cannot open table's browse view

  14. 14

    .htaccess doesn't work on xampp (windows 7)

  15. 15

    CSS Table Cell doesn't become full width

  16. 16

    html footer doesn't work

  17. 17

    HttpPost addHeader doesn't work

  18. 18

    在/usr/share/phpMyAdmin/libraries/Error.class.php中找不到phpMyAdmin类'PMA_Message'

  19. 19

    Adwords conversion tracking doesn't work

  20. 20

    Doesn't work EditText padding in the API 21

  21. 21

    #1146-表'database.table'与连接不存在吗?

  22. 22

    #1146-表'phpmyadmin.pma__tracking'不存在如何手动禁用?

  23. 23

    Ember 1.12.0 instance initializer: deferReadiness method doesn't exist

  24. 24

    Why doesn't django dumpdata include the django_migrations table?

  25. 25

    Hibernate ImprovedNamingStrategy doesn't work

  26. 26

    phpmyadmin显示错误#1064 alter table

  27. 27

    #1146-联接中不存在表'database.table'吗?

  28. 28

    #145-表'。\ phpmyadmin \ pma_recent'被标记为已崩溃,应进行修复

  29. 29

    #1146-表'phpmyadmin.pma__tracking'不存在如何手动禁用?

热门标签

归档