PHPMyAdmin’s default configuration has the following directive:
1 | $cfg['MaxTableList'] = 250; |
In order to override this setting all you need to do is add the following entry to your config.inc.php file in the PHPMyAdmin root folder:
1 | $cfg['MaxTableList'] = 50; |
This did the trick for me and the table list loaded much faster. However, the number of pages that would show me the tables increased, that is due to the above setting of showing 50 tables at once, PhpMyAdmin applied pagination to all my tables with 6 pages. In order to remove pagination just set the following settings:
1 | $cfg['MaxTableList'] = 680; |
However, you should choose the above value according to your convenience. That is the DB I was working with had close to 675 tables to the 680 in the above setting did the trick for me. Generalising that, the value you should enter in that setting should be more than the total number of tables in that Database in order to remove pagination.
Source: http://digitizor.com/max-tables-phpmyadmin/