Can't drop tables in phpMyAdmin because they are not visible in structure

I have a local development environment with MAMP. In this environment, I am using MySQL at version 5.6.35.

When I now want to import a database from phpMyAdmin, I get an internal server error every time I try.

After some research, I think there is a problem with the structure of the mysql database.

I encountered the following error in the logs:

InnoDB: Error: Table "mysql". "innodb_table_stats" was not found.

And a hint to this page: https://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html

There is also a link to the solution: mysql error: "mysql" table. "innodb_table_stats" not found

My problem is that I cannot delete from mysql tables (innodb_index_stats, innodb_table_stats, slave_master_info, slave_relay_log_info, slave_worker_info). They appear in the sidebar, but not in the structure itself.

enter image description here

And if I click on them I get more errors:

enter image description here

What I could have done and have already done is remove the .frm and .ibd files from the tables above. But it had no effect.

Is there a way to restore or replace mysql db?

I also tried the replacement and update tools from MAMP. No success.

+3


source to share


1 answer


I could solve the problem after I also deleted the .ibd files in the folder: / Library / Application Support / appsolute / MAMP PRO / db / mysql56



0


source







All Articles