Phpmyadmin is not showing all tables in a mysql database
centos, mysql, php, phpmyadmin, sql
Solution
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
Problem
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 :)