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.

No comments:

Post a Comment

Related Posts Plugin for WordPress, Blogger...