如何在不影响其他表的情况下从 mysql 中删除 pma 表 [英] How do I remove pma tables from mysql without affecting other tables
问题描述
我的 phpMyAdmin 安装有问题.我不小心点击了创建 phpMyAdmin 使用的 pma 表的东西.(可能是高级功能).
I have a problem with my phpMyAdmin installation. I accidentally clicked something that creates the pma tables used by phpMyAdmin. (Probably advance features).
[
我有一些问题:
- 这会影响其他表吗?
- 这张表有什么用?
- 如何完全禁用 phpMyAdmin 中的高级功能，从而删除这些 pma 表?
- 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 提供为您创建这些表来存储程序高级功能的配置信息.这些表是可选的.通常它们被放在phpmyadmin"数据库中，但如果您无权创建新数据库，则可以将这些表放在您有权访问的数据库中.根据您的评论，这似乎就是这里发生的事情.
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.
您可以通过任何删除表的常用方法来删除它们 - 从每个表本身转到操作选项卡并单击删除表 (DROP)"链接，或转到数据库结构选项卡，选择以pma__"开头的那些，然后从With selected:"下拉框中选择Drop".
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.
回答您的其他问题:
这会影响其他表吗?
不是，每个表的操作是相互独立的.
No, the operation of each table is rather independent of each other.
这个表有什么用?
各种 phpMyAdmin 功能，例如图形表关系编辑器、查询历史记录和书签以及用户首选项.
Various phpMyAdmin features like a graphical table relation editor, query history and bookmarks, and user preferences.
如何完全禁用 phpMyAdmin 中的高级功能，从而删除这些 pma 表?
How can I completely disable advanced features in phpMyAdmin and so remove these pma tables?
只需删除表格.要完全删除有关丢失表的任何警告，您可以编辑 config.inc.php 文件以添加 $cfg['PmaNoRelation_DisableWarning'] = true;并禁用自动创建这些添加 $cfg['ZeroConf'] = false;
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;
这篇关于如何在不影响其他表的情况下从 mysql 中删除 pma 表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
