1 Function Description
1.1 database missing data table user_aiAlarm_shield
1.2 causes the pc client to fail to log in, and the web login prompt system is abnormal.
1.3 execution of SQL statement to create data table failed;
2 Operating Instructions
2.1 Database Folder Search File Deleted;
2.2 the path of querying the normal database;
2.3 copy the frm file of another table and change the file name of this file to the file name of the table to be restored;
Execute SQL statements: drotable user_aiAlarm_shield; delete; 2.4;
After the 2.5 is executed, if you look at the folder again, you will find that the ibd file of the table still exists, and the file has been deleted.
2.6 After manually deleting the ibd file of the table name, re- executing the table creation SQL statement will find that the table is successful and the table is restored, but the data in the table cannot be restored;
3 Notes
3.1 Parameter Document http://blog.sina.com.cn/s/blog_12d36cbf00102wv9d.html
