Showing posts with label tables are not visible in phpmyadmin. Show all posts
Showing posts with label tables are not visible in phpmyadmin. Show all posts

Saturday, March 8, 2014

phpmyadmin - Database imported successfully but tables are not visible

phpmyadmin not showing tables

List the views in the database using following query
SHOW FULL TABLES IN database_name WHERE TABLE_TYPE LIKE 'VIEW';
Just edit the database_name in above query, it will list all the views of database.
Remove all the views.

Now the tables will be visible.