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,510 points
6,074 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,365 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,560 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
4,808 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,075 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
3,852 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
2,997 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
896 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
829 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,260 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
52,242 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