MySQL 1050 Table './crm/insight ' already exists

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