Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to change maximum viewable tables from 250 to anything in PhpMyadmin?

Tags:

php

mysql

I am trying to increase my list of tables to 5000 in phpmyadmin

The documentation says this:

 $cfg['MaxNavigationItems']
 Type:  integer
 Default value: 250

I have tried to set it in the back end to no avail under

settings>navigation panel>Maximum items in branch

How can I do this, I have tons of table on multi site that I often need to delete and don't want to have to keep clicking next and next after only 250 entries...

enter image description here

like image 945
Bruno Vincent Avatar asked Oct 27 '25 20:10

Bruno Vincent


1 Answers

Thank you to juergen d , for other beginners, add the code

 $cfg['MaxTableList'] = 5000; 

to the file config.inc.php, it's not in there to be changed, so can't find it , it needs to be ADDED to the file.

File is located at

C:\xampp\php 

in my case.

PS. There is a box in Phpmyadmin to change the value, but it doesn't work, even after restart, not sure why, but the solutions above works.

like image 87
Bruno Vincent Avatar answered Oct 29 '25 11:10

Bruno Vincent



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!