How can I solve the 1067 error that cannot be started in MySQL?

A power outage occurred during the creation of a table primay key this morning. When the computer started up again, it was found that the mysql service could not be started. The net start error 1067 was prompted, after two hours, the problem could not be solved. Later, you could only manually delete the data files, log files, start the service, and then import the data.

Error 1067 occurred when starting the service:

1. Delete the user database files and log files (ib_logfile0, ib_logfile1) under datadir ).

2. Delete the innodb tablespace ibdata1

3. Start the mysql service:

4. import data:

5. Maximum query data:

Although this method is simple, you need to restore the data file generated by mysqldump.