如何在不影响其他表的情况下从mysql中删除pma表

本文介绍了如何在不影响其他表的情况下从mysql中删除pma表的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我的phpMyAdmin安装有问题.我不小心单击了创建phpMyAdmin使用的 pma 表的内容. (可能是高级功能).

[

我有一些问题:

这会影响其他表吗?

此表的用途是什么?

如何完全禁用phpMyAdmin中的高级功能，然后删除这些 pma 表?

解决方案

phpMyAdmin可以创建这些表，以供您存储配置信息以实现程序的高级功能.这些表是可选的.通常将它们放在"phpmyadmin"数据库中，但是如果您没有创建新数据库的权限，则可以将表放入您有权访问的数据库中.根据您的评论，这似乎就是这里发生的情况.

您可以通过任何一种常用方法来删除它们，以删除表-从每个表本身转到操作"选项卡，然后单击删除表(DROP)"链接，或者转到数据库结构"选项卡，选择以'pma__'开头的那些，然后从选择时:"下拉框中选择删除".

您可能会遇到一个错误，该错误是由删除该错误后尝试写入历史表而导致的，在这种情况下，注销并重新登录应该可以为您清除错误. /p>

要回答您的其他问题:

这会影响其他表吗?

不，每个表的操作都相互独立.

此表的用途是什么?

各种phpMyAdmin功能，例如图形表关系编辑器，查询历史记录和书签以及用户首选项.

如何完全禁用phpMyAdmin中的高级功能，然后删除这些pma表?

只需删除表.要完全删除有关丢失表的任何警告，可以编辑config.inc.php文件以添加$cfg['PmaNoRelation_DisableWarning'] = true; 并禁用自动创建这些添加$cfg['ZeroConf'] = false;

的可能性

I have a problem with my phpMyAdmin installation. I accidentally clicked something that creates the pma tables used by phpMyAdmin. (Probably advance features).

[

I have some Questions:

Does this affect other tables?

What is the use of this table?

How can I completely disable advanced features in phpMyAdmin and so remove these pma tables?

解决方案

phpMyAdmin offers to create these tables for you to store configuration information for advanced functionality of the program. The tables are optional. Usually they're put in the 'phpmyadmin' database, but in the event that you don't have permission to create a new database the tables can be put in the database to which you do have access. Based on your comments, that seems to be what happened here.

You can remove them through any of the usual means to remove a table — either from each table itself go to the Operations tab and click the "Delete the table (DROP)" link, or go to the database Structure tab, select the ones that start with 'pma__', and pick 'Drop' from the "With selected:" dropdown box.

There's a chance that you'll run in to an error caused by it trying to write to the history table after you've removed that one, in that case logging out and logging back in should clear the error for you.

To answer your other questions:

Does this affect other tables?

No, the operation of each table is rather independent of each other.

What is the use of this table?

Various phpMyAdmin features like a graphical table relation editor, query history and bookmarks, and user preferences.

How can I completely disable advanced features in phpMyAdmin and so remove these pma tables?

Simply remove the tables. To completely remove any warning about the missing tables, you can edit the config.inc.php file to add $cfg['PmaNoRelation_DisableWarning'] = true; and to disable the possibility of automatically creating these add $cfg['ZeroConf'] = false;