All geek questions in one place

# 1146 - Table "phpmyadmin.pma__tracking" does not exist

Problem opening any of my databases in phpMyadmin I tried to delete a lot of old, irrelevant databases and maybe in the process deleted something that I didn’t have and was wondering what I can do to fix the error.

# 1146 - Table "phpmyadmin.pma__tracking" does not exist

+10
source share
5 answers

All phpMyAdmin tables are defined in a SQL dump that comes with the package in sql / create_tables.sql . You can import the whole file (also re-create any other tables that you could delete) or simply 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. Then you can use the "SQL" tab to execute this query directly in the database.

+21
source

I had this problem after installing XAMPP. I have done the following:

  • In /opt/lampp/bin1 use ./mysql_upgrade -u root with the -p option if you use a password.
  • In /opt/lampp/var/mysql/phpmyadmin rm all *.ibd files.
  • Import create_tables.sql into phpMyAdmin GUI or run it in the console.
+3
source

Had a similar problem.

I created pma __ tables in my db project by clicking something on the operations tab of this db.

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

Fixed it by running the modified sql / create_table.sql on my db. Had to remove phpmyadmin creation and use there.

+1
source

I had this problem when I switched from mysql to maraidb . The solution was to do the following: run the script creation tables from the console.

Get a terminal

  $ mysql -uroot -padmin

Then import create phpmyadmin db and tables script, I got it from Oldskool answer above. (READ IT BEFORE LAUNCHING)

  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) ...

If there is an error, you can delete the previous phpmyadmin db that you tried to add.

0
source

You can solve it in just 1 second !

just use this url:

 http://127.0.0.1/phpmyadmin/

instead

 http://localhost/phpmyadmin/
0
source

Source: https://habr.com/ru/post/970375/

More articles:


All Articles