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 again 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;
No comments:
Post a Comment