How to list all tables in the left menu of PhpMyAdmin?

Question

Does anyone know how to list each table (disable pagination) in the PhpMyAdmin left menu? I have more than 250 tables in my database, and now we see this. It is very annoying that you need to go back and forth, and it would be much easier if they were all listed.

We found the following variable:

$cfg['LeftDisplayTableFilterMinimum'] = 30 

However, when I put it in our configuration file, it does not seem to be affected.

The documentation says that to install a large number of outages, we tried to do this without success.

Any help would be greatly appreciated!

Answer 1

Update:

Thanks to @Cloudkiller, there is another configuration parameter that may need to be changed (starting from 4.3.6) in addition to Update V4:

$cfg['FirstLevelNavigationItems']

V4 update:

According to the configuration documentation you can change:

$cfg['MaxNavigationItems']

The number of items that can be displayed on each page of the navigation tree.

You can also try:

$cfg['MaxTableList']

The maximum number of table names displayed in the list of main panels (except for the export page). This limit is also applied on the navigation bar in the Light mode.

Answer 2

According to phpMyAdmin, this is MaxNavigationItems:

 $cfg['MaxNavigationItems'] Type: integer Default value: 25 

The number of items that can be displayed on each page of the navigation tree.

Answer 3

Here's how I did it (using the v. 4.0.5 w / "pmahomme" theme on my shared host):

• Go to the phpMyAdmin homepage (home icon).
• In the "Appearance Settings" section, go to "Advanced Settings ...".
• Select "Navigation Bar" in the second row at the top.
• Change the number in the "Maximum positions in the branch."
• Click "Save."
• Bob is your uncle!

Answer 4

I found it with a small mpemburn answer for my local version (4.0.4) installed via Xampp.

• Go to the phpMyAdmin homepage (home icon).
• Go to the Settings tab
• Select "Navigation Bar"
• Change the number in the "Maximum positions in the branch."
• Click "Save."
• Bob is your uncle!

Answer 5

I just upgraded to 4.3.6 and had to add another setting:

$ cfg ['FirstLevelNavigationItems']

in addition to:

 $cfg['MaxTableList']; $cfg['MaxNavigationItems']; 

Answer 6

This helped me get ALL the tables listed in the left pane.

Answer 7

Based on the documentation, these are the configurations that should complete the task:

 $cfg['NavigationTreeDisplayItemFilterMinimum'] = 500; $cfg['FirstLevelNavigationItems'] = 500;