# 1146 -表的phpmyadmin。pma__tracking”根本不存在

时间:2023-01-30 08:23:46

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 个解决方案

#1


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”选项卡直接在数据库上执行这个查询。

#2


1  

Had similar problem.

有类似的问题。

I created pma__ tables in my project db by clicking something in operations tab of that db.

我在项目db中创建了pma__表,在db的operations选项卡中单击某个东西。

Then I deleted my db, created new with the same name and got "table does not exist" problem.

然后我删除了我的db,用相同的名字创建了一个新的,并且得到了“表不存在”的问题。

Fixed it by executing modified sql/create_table.sql on my db. Had to delete phpmyadmin db creation and use from there.

通过执行修改的sql/create_table来修复它。sql数据库。必须删除phpmyadmin db的创建和使用。

#3


1  

I had this problem after installed XAMPP. I did the following:

我在安装XAMPP后遇到了这个问题。我做了以下几点:

  1. In /opt/lampp/bin1 use ./mysql_upgrade -u root with option -p if you use a password.
  2. 在/opt/lampp/bin1中使用。/mysql_upgrade -u root with option -p如果你使用密码。
  3. In /opt/lampp/var/mysql/phpmyadmin rm all *.ibd files.
  4. 在/opt/lampp/var/mysql/phpmyadmin rm all *。炎症性肠病的文件。
  5. Import create_tables.sql in phpMyAdmin GUI or run it in console.
  6. 进口create_tables。phpMyAdmin GUI中的sql或在控制台运行它。

#4


0  

I had this issue when I switched from mysql to maraidb. The solution was to do the following, run the create tables script from the console.

当我从mysql切换到maraidb时,我遇到了这个问题。解决方案是执行以下操作,从控制台运行create tables脚本。

Get to the terminal

到达码头

   $ mysql -uroot -padmin

Then import the create phpmyadmin db and tables script, I got it from Oldskool's answer above. (READ it before running it)

然后导入创建phpmyadmin db和tables脚本,从上面的老skool的答案中得到。(在运行之前阅读它)

 MariaDB [(none)]> source create_tables_phpmyadmin.sql;
 Query OK, 1 row affected (0.00 sec)

 Database changed
 Query OK, 0 rows affected (0.02 sec)
 ...

In case of exists error you may clear your previous phpmyadmin db that you had tried adding.

如果存在错误,您可以清除之前尝试添加的phpmyadmin db。

#1


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”选项卡直接在数据库上执行这个查询。

#2


1  

Had similar problem.

有类似的问题。

I created pma__ tables in my project db by clicking something in operations tab of that db.

我在项目db中创建了pma__表,在db的operations选项卡中单击某个东西。

Then I deleted my db, created new with the same name and got "table does not exist" problem.

然后我删除了我的db,用相同的名字创建了一个新的,并且得到了“表不存在”的问题。

Fixed it by executing modified sql/create_table.sql on my db. Had to delete phpmyadmin db creation and use from there.

通过执行修改的sql/create_table来修复它。sql数据库。必须删除phpmyadmin db的创建和使用。

#3


1  

I had this problem after installed XAMPP. I did the following:

我在安装XAMPP后遇到了这个问题。我做了以下几点:

  1. In /opt/lampp/bin1 use ./mysql_upgrade -u root with option -p if you use a password.
  2. 在/opt/lampp/bin1中使用。/mysql_upgrade -u root with option -p如果你使用密码。
  3. In /opt/lampp/var/mysql/phpmyadmin rm all *.ibd files.
  4. 在/opt/lampp/var/mysql/phpmyadmin rm all *。炎症性肠病的文件。
  5. Import create_tables.sql in phpMyAdmin GUI or run it in console.
  6. 进口create_tables。phpMyAdmin GUI中的sql或在控制台运行它。

#4


0  

I had this issue when I switched from mysql to maraidb. The solution was to do the following, run the create tables script from the console.

当我从mysql切换到maraidb时,我遇到了这个问题。解决方案是执行以下操作,从控制台运行create tables脚本。

Get to the terminal

到达码头

   $ mysql -uroot -padmin

Then import the create phpmyadmin db and tables script, I got it from Oldskool's answer above. (READ it before running it)

然后导入创建phpmyadmin db和tables脚本,从上面的老skool的答案中得到。(在运行之前阅读它)

 MariaDB [(none)]> source create_tables_phpmyadmin.sql;
 Query OK, 1 row affected (0.00 sec)

 Database changed
 Query OK, 0 rows affected (0.02 sec)
 ...

In case of exists error you may clear your previous phpmyadmin db that you had tried adding.

如果存在错误,您可以清除之前尝试添加的phpmyadmin db。