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 in PHP by kartik
• 35,300 points
21 views

1 answer to this question.

0 votes

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 by Niroj
• 76,540 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 17 in PHP by Niroj
• 76,540 points
55 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 in PHP by Niroj
• 76,540 points
146 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 in PHP by Niroj
• 76,540 points
75 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 in PHP by Niroj
• 76,540 points
14 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 in Java-Script by Niroj
• 76,540 points
437 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 in Java-Script by Niroj
• 76,540 points
672 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 in PHP by Niroj
• 76,540 points
89 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 in Node-js by Niroj
• 76,540 points
87 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 in PHP by Niroj
• 76,540 points
73 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 in PHP by Niroj
• 76,540 points
906 views