Wednesday 28 December 2016

[Warning] InnoDB: Cannot open table mysql/innodb_index_stats || InnoDB error for MySQL5.6 in MAMP

I did the procedure on a clean installed MAMP (with MySQL5.6 latest till now date) and it worked for me, atleast it gets rid from errors in the "/Applications/MAMP/logs/mysql_error_log.err" and use of transient tables and yes it would be a temporary fix so do it as your own risk

 Steps to be follow:

 -> Drop below tables from mysql database: innodb_index_stats, innodb_table_stats, slave_master_info, slave_relay_log_info, slave_worker_info
 i.e DROP TABLE if exists <TABLE_NAME>

-> Delete all .frm and.ibd of the tables above i.e rm "/Applications/MAMP/db/mysql56/mysql"/ <TABLE_NAME.frm>

-> run/download five tables to create tables above again, either run SQL or import SQL

-> restart MAMP (basically we need to restart mysql server only)

Cheers!

No comments:

Post a Comment