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!
The easiest way to find all tables in SQL is to query the INFORMATION_SCHEMA views. You do this by specifying the information schema, then the “tables” view. Here's an example. SELECT table_name, table_schema, table_type FROM information_schema.
Once a table is hidden, a light bulb or eye (depending on version) should appear next to the database name. Click on that, and it will bring up a dialog box with the hidden tables, allowing you to unhide (show) them.
On the phpMyAdmin home screen click Settings >> Main frame >> Browse mode and altering the value within Maximum number of rows to display . +1!
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']
According to Configuration Docs, you can modify:
$cfg['MaxNavigationItems']
The number of items that can be displayed on each page of the navigation tree.
$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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With