How to list all tables in PhpMyAdmin's left menu?

Php Problem Overview

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.

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 Documentation it says to set it to a big number to disable, we tried that as well with no success.

Any help would be greatly appreciated!

Php Solutions

Solution 1 - Php

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:

$cfg['FirstLevelNavigationItems']

Update V4:

According to Configuration Docs, you can modify:

$cfg['MaxNavigationItems']

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

Can also try:

$cfg['MaxTableList']

> 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.

Solution 2 - Php

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

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!

Solution 3 - Php

According to phpMyAdmin it is MaxNavigationItems:

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

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

Solution 4 - Php

I found it via a slight variation to mpemburn's answer for my local version (4.0.4) installed via Xampp.

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!

Solution 5 - Php

As of phpMyAdmin 4.8.5.

Click the cog icon at the top left under the phpMyAdmin logo.
Click on the Navigation Tree tab.
Increase the number of Maximum items in branch.

Solution 6 - Php

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

> $cfg['FirstLevelNavigationItems']

in addition to:

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

Solution 7 - Php

This worked for me to get ALL the tables listed in the left pane.

Solution 8 - Php

Based on the documentation these are the configurations that should do the job:

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

Solution 9 - Php

When I use the settings from the interface, then log out and login again, it is back to default, i.e. showing 50 entries.

Solution for 5.0+:

Rename config.sample.inc.php to config.inc.php (don't forget the "inc" part)
Open file.
Add to last line: $cfg['MaxNavigationItems'] = 500;
Open PhpMyAdmin and the navigation items are listend (500 entries).

Reference: Configuration file
Reference: $cfg['MaxNavigationItems']

Content Type	Original Author	Original Content on Stackoverflow
Question	thiesdiggity	View Question on Stackoverflow
Solution 1 - Php	SeanWM	View Answer on Stackoverflow
Solution 2 - Php	mpemburn	View Answer on Stackoverflow
Solution 3 - Php	Bokw	View Answer on Stackoverflow
Solution 4 - Php	Paul Wright	View Answer on Stackoverflow
Solution 5 - Php	Lemmings19	View Answer on Stackoverflow
Solution 6 - Php	Craig	View Answer on Stackoverflow
Solution 7 - Php	Apps-n-Add-Ons	View Answer on Stackoverflow
Solution 8 - Php	Efren Valdez	View Answer on Stackoverflow
Solution 9 - Php	Avatar	View Answer on Stackoverflow