Showing posts with label phpMyAdmin not listing existing tables. Show all posts
Showing posts with label phpMyAdmin not listing existing tables. 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.