phpMyAdmin error: Table doesn't exist in engine

Question

I installed XAMPP today on Ubuntu 14.04. I tried to create a new database in phpMyAdmin but received the error

#1932 - Table 'phpmyadmin.pma__tracking' doesn't exist in engine

So I Googled a bit and I saw I should import create_tables.sql located in /usr/share/doc/phpmyadmin/example (if I remember correctly, but I couldn't locate it there, but I did locate it in /opt/lampp/phpmyadmin/sql. So I tried to import it, but I receive the same error.

First I installed XAMPP 5.6.14 / PHP 5.6.14 twice, but no change. Then I installed XAMPP 5.5.30 / PHP 5.5.30, but still no change. I also tried changing the config.inc.php file (then I stop XAMPP and start it again).

Note: I can see the phpmyadmin database and if I expand it I can see that all the tables that are giving problems, do exist:

I have no idea why this is happening or how to solve it. Can anyone please help?

PS: I have seen that this question has been asked before, but none of the answers I found worked for me.

Armand Maree · Accepted Answer · 2015-11-29 16:50:11Z

3

Since none of the solutions worked for me I did the following:

Open Nautilus (Linux's file explorer) with root privileges: sudo nautlius.
Navigate to the mysql directory: /opt/lampp/var/mysql.
Delete the phpmyadmin folder. This is the phpmyadmin database in phpMyAdmin
Copy the content of the create_tables.sql (found at /opt/lampp/phpmyadmin/sql) file to another one on the desktop called sql.sql
Open the MySQL command line interface: /opt/lampp/bin/mysql -uroot -p
Then in the mysql promp I ran the script to create the database phpmyadmin with source /home/user/Desktop/sql.sql

That solved the problem for me.

answered Nov 29, 2015 at 16:50

Armand Maree

4902 gold badges7 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Community · Accepted Answer · 2017-05-23 12:26:24Z

0

I made it working with some changes in /opt/lampp/phpmyadmin/config.inc.php:

Add a $i=1 after /* server parameters */

/* Server parameters */

$i = 1

AND fix tablespaces of phpMyAdmin as written in

1932-table-phpmyadmin-pma-tracking-doesnt-exist-in-engine

edited May 23, 2017 at 12:26

CommunityBot

11 silver badge

answered Nov 27, 2015 at 21:28

Furqan Aziz

1,1149 silver badges18 bronze badges

Comments

Rajitha Bandara · Accepted Answer · 2015-12-12 10:45:22Z

0

I did not want to run create_tables.sql as pointed in other answers. I added below line after Servers configuration.

/*
 * Servers configuration
 */
$i = 1;

Then I logged out from phpMyAdmin and logged in again. Problems were solved there. Logout seems to be important here.

answered Dec 12, 2015 at 10:45

Rajitha Bandara

7511 gold badge10 silver badges16 bronze badges

Comments

Anika · Accepted Answer · 2022-09-30 10:08:52Z

0

If anyone get that error while exporting database from Laragon and trys to import anywhere else: make sure you check "create tables" and chose "Insert" in select list before running export

answered Sep 30, 2022 at 10:08

Anika

1

1 Comment

Community Over a year ago

As it’s currently written, your answer is unclear. Please edit to add additional details that will help others understand how this addresses the question asked. You can find more information on how to write good answers in the help center.

Collectives™ on Stack Overflow

phpMyAdmin error: Table doesn't exist in engine

4 Answers 4

Comments

Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related