How to unhide a hidden table in PHPMyAdmin 4+?

Question

I really thought there would be more answers on this already. However, I'm using PhPMyAdmin 4.3, and I accidently clicked the light bulb to hide a table. Now I can't find where to get it back.

Anyone??

Thanks.. sorry if this is obvious.

Answer 1

Once a table is hidden, a light bulb or eye (depending on version) should appear next to the database name. Click on that, and it will bring up a dialog box with the hidden tables, allowing you to unhide (show) them.

Answer 2

Interesting. This seems to have been a bug, at first. However, here is what I found.

If you have turned on the "Group Items In The Tree" setting, the lightbulb that appears by the table listings WILL hide the table. However, the lightbulb to view hidden tables (and un-hide them) will NOT appear if this setting is on.

If you do not have this setting turned on, and you have hidden a table, hovering over the database name will give you a yellow lightbulb that allows you to view hidden tables within that database. You can "show" them again using that menu.

But..

If you turn this setting OFF, and then turn it back ON, the lightbulb will now appear next to the database when you hover over it.. even with this setting turned on. I just tried this on three new PhpMyAdmin installations, and it was consistent on all three.

Anyway.. hope this is useful to some. Unless someone has something to add that I missed, I'll mark this as my answer in a day or two.

Take care...