phpMyAdmin 错误:引擎中不存在表 [英] phpMyAdmin error: Table doesn't exist in engine
问题描述
我今天在 Ubuntu 14.04 上安装了 XAMPP.我试图在 phpMyAdmin 中创建一个新数据库,但收到错误
I installed XAMPP today on Ubuntu 14.04. I tried to create a new database in phpMyAdmin but received the error
#1932 - 引擎中不存在表phpmyadmin.pma__tracking"
#1932 - Table 'phpmyadmin.pma__tracking' doesn't exist in engine
所以我用谷歌搜索了一下,我看到我应该导入位于 /usr/share/doc/phpmyadmin/example
的 create_tables.sql
(如果我没记错的话,但是我在那里找不到它,但我确实在 /opt/lampp/phpmyadmin/sql
中找到了它.所以我尝试导入它,但我收到了同样的错误.
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.
首先我安装了 XAMPP 5.6.14/PHP 5.6.14 两次,但没有任何变化.然后我安装了 XAMPP 5.5.30/PHP 5.5.30,但仍然没有变化.我还尝试更改 config.inc.php 文件(然后我停止 XAMPP 并重新启动它).
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).
注意:我可以看到 phpmyadmin 数据库,如果我展开它,我可以看到所有出现问题的表确实存在:
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:我看到之前有人问过这个问题,但我找到的答案都不适合我.
PS: I have seen that this question has been asked before, but none of the answers I found worked for me.
推荐答案
由于所有解决方案都不适合我,我做了以下操作:
Since none of the solutions worked for me I did the following:
- 以 root 权限打开 Nautilus(Linux 的文件浏览器):
sudo nautlius
. - 导航到 mysql 目录:
/opt/lampp/var/mysql
. - 删除 phpmyadmin 文件夹.这是phpMyAdmin中的phpmyadmin数据库
- 将
create_tables.sql
(位于/opt/lampp/phpmyadmin/sql
)文件的内容复制到桌面上另一个名为sql 的文件中.sql
- 打开MySQL命令行界面:
/opt/lampp/bin/mysql -uroot -p
- 然后在 mysql 提示中,我运行脚本以使用
source/home/user/Desktop/sql.sql
创建数据库
phpmyadmin
- 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 calledsql.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
withsource /home/user/Desktop/sql.sql
这为我解决了问题.
这篇关于phpMyAdmin 错误:引擎中不存在表的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!