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...

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.
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