php 如何在 PhpMyAdmin 的左侧菜单中列出所有表？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/14245441/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
How to list all tables in PhpMyAdmin's left menu?
提问by thiesdiggity
Does anyone know how to list every table (disable the pagination) in PhpMyAdmin's left menu? I have over 250 tables in my DB and now we are seeing the pageination. It's very annoying having to go back and forth and would be much easier to have them all listed.
有谁知道如何在 PhpMyAdmin 的左侧菜单中列出每个表（禁用分页）？我的数据库中有 250 多个表，现在我们看到了分页。必须来回走动非常烦人，而且将它们全部列出会容易得多。
We found the following variable:
我们发现了以下变量：
$cfg['LeftDisplayTableFilterMinimum'] = 30
However, when I put it into our config file it doesn't appear to have any affect.
但是，当我将它放入我们的配置文件时，它似乎没有任何影响。
In the Documentationit says to set it to a big number to disable, we tried that as well with no success.
在文档中它说将其设置为一个大数字以禁用，我们也尝试过但没有成功。
Any help would be greatly appreciated!
任何帮助将不胜感激！
回答by SeanWM
Update:
更新：
Thanks to @Cloudkiller, there's another configuration setting that might need to be changed (as of 4.3.6) in addition to Update V4:
感谢@Cloudkiller，除了更新 V4 之外，还有另一个配置设置可能需要更改（从 4.3.6 开始）：
$cfg['FirstLevelNavigationItems']
$cfg['FirstLevelNavigationItems']
Update V4:
更新 V4：
According to Configuration Docs, you can modify:
根据Configuration Docs，您可以修改：
The number of items that can be displayed on each page of the navigation tree.
导航树每页可以显示的项目数。
Can also try:
也可以试试：
The maximum number of table names to be displayed in the main panel's list (except on the Export page). This limit is also enforced in the navigation panel when in Light mode.
要在主面板列表中显示的最大表名数（导出页面除外）。在 Light 模式下，导航面板中也会强制执行此限制。
回答by mpemburn
Here's how I did this (using v. 4.0.5 w/ "pmahomme" theme on my shared host):
这是我如何做到的（在我的共享主机上使用 v. 4.0.5 w/“pmahomme”主题）：
- Go to the phpMyAdmin Home page (house icon).
- Under "Appearance Settings", go to "More Settings...".
- Select "Navigation Panel" in the second row from the top.
- Change the number in "Maximum items in branch".
- Click "Save"
- Bob's your uncle!
- 转到 phpMyAdmin 主页（房子图标）。
- 在“外观设置”下，转到“更多设置...”。
- 选择顶部第二行的“导航面板”。
- 更改“分支中的最大项目数”中的数字。
- 点击“保存”
- 鲍勃是你的叔叔！
回答by Bokw
According to phpMyAdmin it is MaxNavigationItems:
根据 phpMyAdmin，它是 MaxNavigationItems：
$cfg['MaxNavigationItems']
Type: integer
Default value: 25
The number of items that can be displayed on each page of the navigation tree.
导航树每页可以显示的项目数。
回答by Paul Wright
I found it via a slight variation to mpemburn's answer for my local version (4.0.4) installed via Xampp.
我通过对通过 Xampp 安装的我的本地版本 (4.0.4) 的 mpemburn 的答案略有不同发现了它。
- Go to the phpMyAdmin Home page (house icon).
- Click "Settings" tab
- Select "Navigation Panel"
- Change the number in "Maximum items in branch".
- Click "Save"
- Bob's your uncle!
- 转到 phpMyAdmin 主页（房子图标）。
- 点击“设置”标签
- 选择“导航面板”
- 更改“分支中的最大项目数”中的数字。
- 点击“保存”
- 鲍勃是你的叔叔！
回答by Lemmings19
As of phpMyAdmin 4.8.5.
从 phpMyAdmin 4.8.5 开始。
- Click the cog icon at the top left under the phpMyAdmin logo.
- Click on the
Navigation Treetab. - Increase the number of
Maximum items in branch.
- 单击 phpMyAdmin 徽标下方左上角的齿轮图标。
- 单击
Navigation Tree选项卡。 - 增加
Maximum items in branch.
回答by Craig
I have just upgraded to 4.3.6and had to add another setting:
我刚刚升级到4.3.6，不得不添加另一个设置：
in addition to:
此外：
$cfg['MaxTableList'];
$cfg['MaxNavigationItems'];
回答by CFP Support
This worked for me to get ALL the tables listed in the left pane.
这对我有用，可以获取左窗格中列出的所有表。
回答by Efren Valdez
Based on the documentation these are the configurations that should do the job:
根据文档，这些是应该完成这项工作的配置：
$cfg['NavigationTreeDisplayItemFilterMinimum'] = 500;
$cfg['FirstLevelNavigationItems'] = 500;
