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

php database-design phpmyadmin
thiesdiggity picture thiesdiggity · Jan 9, 2013 · Viewed 37.6k times · Source

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!

Answer

SeanWM picture SeanWM · Jan 9, 2013

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.

Related questions

Does VARCHAR size limit matter?

Possible Duplicate: Importance of varchar length in MySQL table When using VARCHAR (assuming this is the correct data type for a short string) does the size matter? If I set it to 20 characters, will that take up less space or …

Read More
Soft delete best practices (PHP/MySQL)

Problem In a web application dealing with products and orders, I want to maintain information and relationships between former employees (users) and the orders they handled. I want to maintain information and relationships between obsolete products and orders which include …

Read More
MySQL: Understanding mapping tables

When building a category navigation system for a business directory with a many to many relationship, I understand that it is good practise to create a mapping table. Category Table ( CategoryId, CategoryName ) Business Table ( BusinessId, BusinessName ) Category Mapping Table ( BusinessId, …

Read More