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

Source: Internet
Author: User

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.