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

Question

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!

score 99 · Accepted Answer · edited Jun 20 '20 at 09:12

99

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.

edited Jun 20 '20 at 09:12

Community

1
1

answered Jan 09 '13 at 20:03

SeanWM

16,789
7
51
83

3

In fact, `MaxTableList` should be (as seen in the documentation) for `The maximum number of table names to be displayed in the RIGHT panel's list.`. Note the "RIGHT" panel, not the left one. – elboletaire Aug 14 '13 at 09:29

score 74 · Answer 2 · edited Nov 18 '17 at 10:24

74

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!

edited Nov 18 '17 at 10:24

Avatar

14,622
9
119
198

answered Jan 09 '14 at 15:41

mpemburn

2,776
1
35
41

2

When I log out and login again, it is back to showing 50 entries by default. – Avatar Sep 02 '20 at 15:55

score 42 · Answer 3 · edited Nov 18 '13 at 02:01

42

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.

edited Nov 18 '13 at 02:01

Benny Hill

6,191
4
39
59

answered May 06 '13 at 18:42

Bokw

789
1
9
21

3

Additional clarification: This is the setting you want if you're trying to remove the table list pagination that occurs in the nav menu in version 4.0 (new release as of this writing). – Frank Koehl May 08 '13 at 17:18
1

yep, that was the original question, wasn't it? – Bokw May 08 '13 at 19:28
Not exactly, I don't see anything in the original question specifying when this became an issue. If you like, call it Google fodder. – Frank Koehl May 15 '13 at 16:25

score 14 · Answer 4 · answered Jul 24 '14 at 15:09

14

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!

answered Jul 24 '14 at 15:09

Paul Wright

445
5
16

2

In v4.5 after clicking "Navigation Panel" you now need to click the "Navigation tree" sub-panel to see the "Maximim Items in the branch" setting. – Night Owl Mar 17 '16 at 06:22

score 6 · Answer 5 · answered Aug 02 '19 at 16:07

6

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.

answered Aug 02 '19 at 16:07

Lemmings19

1,383
3
21
34

score 2 · Answer 6 · answered Sep 02 '20 at 16:16

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']

score 1 · Answer 7 · edited Mar 27 '17 at 09:40

1

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

$cfg['FirstLevelNavigationItems']

in addition to:

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

edited Mar 27 '17 at 09:40

Siarhey Uchukhlebau

834
14
18

answered Jan 08 '15 at 10:24

Craig

129
4

Just upgraded to 4.3.6 as well and was going crazy trying to find this. Thanks for sharing. – Cloudkiller Jan 14 '15 at 17:27

score 1 · Answer 8 · answered Sep 14 '17 at 15:42

1

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

answered Sep 14 '17 at 15:42

Apps-n-Add-Ons

2,026
1
17
28

score 1 · Answer 9 · edited Oct 18 '17 at 00:52

1

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

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

edited Oct 18 '17 at 00:52

Ibo

4,081
6
45
65

answered Oct 17 '17 at 23:37

Efren Valdez

391
3
3

can you include a reference to the documentation where it states such? – Ibo Oct 17 '17 at 23:59

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

9 Answers9

Update:

Update V4:

Can also try: