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!
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"/
No comments:
Post a Comment