Phpmyadmin is not showing all tables in a mysql database

Question

I have been running a website from home for a few months now and suddenly phpmyadmin is not showing me all the tables in the mysql database.

Here is a screenshot 1:

I thought the database could be corrupt or maybe someone has executed some bad sql code so I deleted the database and tried to restore from a date that I knew was working and the same thing happened. So I built a new server thinking something in phpmyadmin could be corrupt but now I am facing the same issue on the new server.

I tried manually creating the database but after so many tables have been created the same thing happens.

As you can see in the screenshot 1 on the left side it stops after customcars but then in the middle in continues to downloads. There should be more tables but they will not show up.

I have ran a script to check if they exist and they do but I just cannot access them on phpmyadmin

I have tried importing the database with a .sql file and still no luck.

Sometimes it evan looks like this

Notice the way the customcars on the left is missing and so is the X in the middle for downloads.

My Operating System Is Centos 6, Mysql Version 5.1.73, Phpmyadmin 2.11.11.3

Thank you for reading and I hope someone out there has had the same issue so I can fix this asap :)

Solution 1

You might want to check that Settings > Navigation Panel > Maximum items in branch is not set to a low number. http://docs.phpmyadmin.net/en/latest/config.html#cfg_MaxNavigationItems

Solution 2

I had the same issue. I found an eye symbol next to my database name in the left column. When I cliked on the eye symbol I had the option to unhide the missing table. I have no idea how I managed to hide this table but this solved my problem.

Comments

[Admin]

Thank you for the url. This seems to be for the latest version of phpmyadmin but I will upgrade tomorrow and let uses know if it done the job!

[Chris Magnussen]

The option should be there for your version aswell. Just click the home/house button, hit settings and then Navigation Panel.

[SR_]

Thanks so much. In my case it's a bulb icon. The disappearance might have happened because I clicked on the right of the table name by mistake, one day. If your pointer is over a table name, such a grayed bulb appears and allows you to hide the table name. Nice feature but not for clumsy people obviously.

[Elliott Farmer]

yes. I have since found this feature because I managed to accidentally hide another table.

[OMA]

I had this problem. Thanks!!