Magento #1146 - Table doesn't exist

Magento #1146 - Table doesn't exist. I faced a very irritating issue. When i logged in phpmyadmin and looked at a table in left column the table shows. But when i try to open that table by clicking on it , it throws error "#1146 - Table `DB NAME.tag_summary` doesn't exist "

I tried to drop the table and create the table agian but it throws same error "#1146 - Table `DB NAME.tag_summary` doesn't exist".

Below is the solution:

You would need to access the server via SSH and after that navigate to /var/lib/mysql and go to the database folder.

For eg: cd /var/lib/mysql/DATABASE Folder and then delete the table using

rm -rf DB NAME.tag_summary

rm -rf DB NAME.tag_summary.ibd

rm -rf DB NAME.tag_summary.frm

Then connect to mysql by using the command mysql and follow the below steps:

use DB NAME;

DROP TABLE DB NAME.tag_summary;