Delete the MySQL database file, causing the table to not be created. Look at the MySQL log shown below.
150922  9:12:35  INNODB: ERROR; POSSIBLE REASONS:INNODB: 1) Table rename would cause two foreign key constraintsinnodb: to have the same internal name in case-insensitive comparison. INNODB: 2) table ' CRM '. ' Insight ' exists in the InnoDB internal datainnodb: dictionary though mysql is trying to rename table ' CRM '. ' Action_value ' to it. Innodb: have you deleted the .frm file and not used drop table? Innodb: you can look for further help frominnodb: http://dev.mysql.com /doc/refman/5.5/en/innodb-troubleshooting.htmlinnodb: if table ' CRM '. ' Insight ' is a temporary table #sql ...,  THEN IT CAN BE THATINNODB: THERE&Nbsp;are still queries running on the table, and it will Beinnodb: dropped automatically when the queries end. Innodb: you can drop the orphaned table inside innodb byinnodb: creating an InnoDB table with the same name in Anotherinnodb: database and copying the .frm file to the current database. innodb: then mysql thinks the table exists, and drop table Willinnodb: succeed.
Press Log to create the same table from another DB, copy the corresponding insight.frm to the CRM file directory, and then modify theusers and groups that crm/insight.frm belong to to ensure that MySQL has access.
chown MySQL data/crm/insight.frmchgrp MySQL data/crm/insight.frm
Finally drop table insight;
Then we create the insight.
MySQL 1050 Table './crm/insight ' already exists