How to list all tables in PhpMyAdmin s left menu

0 votes

 anyone know how to list every table (disable the pagination) in PhpMyAdmin's left menu? I have over 250 tables in my DB and now we are seeing the pageination. It's very annoying having to go back and forth and would be much easier to have them all listed.

We found the following variable:

$cfg['LeftDisplayTableFilterMinimum']  = 30

However, when I put it into our config file it doesn't appear to have any affect.

Any help would be greatly appreciated!

Oct 20, 2020 in PHP by kartik
• 37,520 points
6,482 views

1 answer to this question.

+1 vote

Hello @kartik,

  1. Go to the phpMyAdmin Home page (house icon).
  2. Under "Appearance Settings", go to "More Settings...".
  3. Select "Navigation Panel" in the second row from the top.
  4. Change the number in "Maximum items in branch".
  5. Click "Save"
Hope it helps!!
answered Oct 20, 2020 by Niroj
• 82,880 points

Related Questions In PHP

0 votes
1 answer

How to get a list of user accounts using the command line in MySQL?

Hello @kartik, Use this query: SELECT User FROM mysql.user; Which ...READ MORE

answered Aug 18, 2020 in PHP by Niroj
• 82,880 points
1,545 views
0 votes
1 answer

How to delete from multiple tables in MySQL?

Hello @kartik, Use a JOIN in the DELETE statement. DELETE p, pa ...READ MORE

answered Aug 26, 2020 in PHP by Niroj
• 82,880 points
3,793 views
0 votes
1 answer

How to import all classes from another namespace in PHP?

Hello @kartik, This is not possible in PHP. All ...READ MORE

answered Oct 20, 2020 in PHP by Niroj
• 82,880 points
5,144 views
0 votes
1 answer

How to delete all cookies of my website in php?

Hello @kartik, This will unset all of the ...READ MORE

answered Oct 27, 2020 in PHP by Niroj
• 82,880 points
8,928 views
0 votes
1 answer

jQuery AJAX fires error callback on window unload - how do I filter out unload and only catch real errors?

Hello, In the error callback or $.ajax you have three ...READ MORE

answered Apr 27, 2020 in Java-Script by Niroj
• 82,880 points
4,145 views
0 votes
1 answer

How do I pass command line arguments to a Node.js program?

Hello @kartik, If your script is called myScript.js ...READ MORE

answered May 5, 2020 in Java-Script by Niroj
• 82,880 points
3,207 views
0 votes
1 answer

Error:Issue when trying to use IN() in wordpress database

Hello @kartik, Try this code : // Create an ...READ MORE

answered May 8, 2020 in PHP by Niroj
• 82,880 points
1,086 views
+2 votes
1 answer

How do I debug Node.js applications?

Hello @kartik, Use node-inspector  from any browser supporting WebSocket. Breakpoints, ...READ MORE

answered Jul 8, 2020 in Node-js by Niroj
• 82,880 points
1,011 views
0 votes
1 answer

How to get all columns' names for all the tables in MySQL?

Hello @kartik, Try this: select * from information_schema.columns where table_schema ...READ MORE

answered Aug 19, 2020 in PHP by Niroj
• 82,880 points
2,564 views
0 votes
1 answer

How to select all records from one table that do not exist in another table?

Hello @kartik, You can either do like this: SELECT ...READ MORE

answered Jul 21, 2020 in PHP by Niroj
• 82,880 points
53,085 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP