phpMyAdmin Increase Tables Displayed in Left Column

If you are using the latest version of phpMyAdmin you have no doubt spotted the nice javascript table select system that allows you to type keywords that filter the list of tables down to the one you are looking for.

However if you are dealing with a system that has a lot of tables, the list is paged and unfortunately this javascript system does not filter the entire table list, just the current page.

The solution is to add one line to your config.inc.php in the phpMyAdmin root.

$cfg['MaxTableList'] = 500;

Tags: mysqlphpproblemsolutionphpmyadmintiptop