Display all tables in the PHPMyAdmin navigation column

Navigation
4

The PHPMyAdmin (English) in these last versions has the number of tables in the left lateral navigation limited, being applied a pagination to them.

I have not only noticed it being something slower than impractical in large databases.

Question

How to disable paging in the left side column of PHPMyAdmin so that all tables are present as in past versions?

If relevant, the version in question is 4.2.3 .

    
asked by anonymous 17.06.2014 / 16:12

1 answer

1

Note: This solution does not disable paging effectively, but the result in practice is the same.

The answer depends on whether you want the settings to always be applied, or only in the current session.

To apply only in the current session:

  • Go to phpMyAdmin home page (house icon)
  • Under "Appearance Settings", click "More Settings ..."
  • Click on "Navigation Panel"
  • Change the number of items in "Maximum items in branch "to a very high value
  • Click "Save"

    • To always apply:

    In this case it is necessary to change the same parameter ("Maximum items in a branch"), but instead of configuring the screen, edit the phpMyAdmin configuration file ( config.inc.php ), changing the default value of the $cfg['MaxNavigationItems'] parameter %.

    More details can be found this phpMyAdmin documentation link .

        
    20.06.2014 / 18:27
    Join SQL tables Detect event generated in another class