38

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.

Lee Fuller
  • 2,116
  • 3
  • 19
  • 27
  • Apparently the hidden tables are stored in the configuration (PMA) database under "navigationhiding" (See http://myadmin.simplescienceinc.com/doc/html/config.html#cfg_Servers_navigationhiding) for details. If there are tables listed in that database table, they are hidden. So far I have not found an interface option to unhide them other than to manually delete them from this table. – Lee Fuller Dec 24 '14 at 18:56
  • 1
    At least you knew you accidentally clicked it. I just spend an hour why my Laravel app is working properly without the table in my database. Then I noticed it's hidden, I really don't think it's good UX to have a obscure hiding button right next to the table names. – Madmenyo Dec 26 '18 at 19:25
  • It's really not obvious. Thought I had a hideous corruption. – Enigma Plus Oct 22 '19 at 09:02

9 Answers9

94

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.

Darryl Hein
  • 142,451
  • 95
  • 218
  • 261
Ben
  • 941
  • 1
  • 5
  • 2
21

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

Lee Fuller
  • 2,116
  • 3
  • 19
  • 27
  • Hey, can you give me a hand? I've hide a table, but I can't figure out how to unhide it. My PHPMyAdmin version is 4.2.5, and I've turned OFF/ON several times the setting 'Group Items in the Tree'. Keep in mind I'm on a real server using PLESK. I don't see any yellow lightbulb. – Linesofcode Feb 19 '15 at 18:18
  • 2
    I made a comment above that can help you. Apparently the hidden tables are stored in the configuration (PMA) database under "navigationhiding" (See myadmin.simplescienceinc.com/doc/html/…) for details. If there are tables listed in that database table, they are hidden. Delete them from that table and they are restored. – Lee Fuller Feb 19 '15 at 21:38
  • 1
    Good answer, but it took me some time to find out where the "Group Items In The Tree" setting is located. It is at Settings-> Navigation panel. – Felipe Alameda A Jul 05 '15 at 20:57
  • "Group Items In The Tree" was on. I turned it on and off several times. Still no pulp next to table name! – Kareem Jun 22 '18 at 14:20
12

I found the answer. If you accidentally click bulb and hide tables, look at the right side of your database name, the bulb lights yellow. click on that and it will show you a window of hidden tables.

Here's the screenshot

Hope this will help :)

Chitto Cancio
  • 121
  • 1
  • 2
9

After mouse over on database name It shows eye icon near it click this icon it show list of your hidden tables from database and option for show. Just click on show and refresh your phpMyAdmin.

image

4b0
  • 21,981
  • 30
  • 95
  • 142
vijay kasar
  • 145
  • 1
  • 12
4

in version 4.7 of phpmyadmin, you would not see a lightbulb but instead you will see at the right side of the database name, a symbole resembling an "eye". click on it. it will open a window displaying a list of your hidden tables then you will see a "show". click on "show". that's all.

Steve Nguenko
  • 41
  • 1
  • 1
0

I faced the same problem and couldn't find the lightbulb next to the database name.

Default phpMyAdmin version 4.x groups tables I think. In settings you can uncheck this and then you see the lightbulb to unHide the tables.

PCvanWijk
  • 13
  • 1
  • 3
0

Well...

I went to pma__navigationhiding table on phpmyadmin database and delete the proper entry...

PJunior
  • 2,649
  • 1
  • 33
  • 29
0

On the right side of the database name, you will see one "eye icon". Just click that then a popup will appear with hidden tables. You just have to click "show". Enjoy :)

Office Assistant
  • 11
0

To hide follow below Image instructions

enter image description here

then we can Un-hide/show the hidden tables By following below Image Instructions : - Eye Icon will appear next to the Database

enter image description here

After Click on the Icon next Pop-up/dialog will be appeared, we should click on unhide/eye icon to unhide tables

enter image description here

Avinash
  • 159
  • 2
  • 9