The MySQL Service Fails to Be Started and Error 1067 Is Reported When the Service Is Manually Started

The MySQL Service Fails to Be Started and Error 1067 Is Reported When the Service Is Manually Started

1. The database is damaged because of an abrupt power failure of the server or other causes.

Countermeasure: Perform the following steps to restore device information. Other data needs to be re-configured. Before performing these operations, negotiate with the customer first.

A. Stop the MySQL-SNC service. Access the SNC installation directory and open the \mysql\my.ini file, add innodb_force_recovery=6 (if the database cannot be opened, set it to 1-5 in sequence for testing) to the end of the file. Then, start the MySQL-SNC service.

B. Install navicat and run the following command to configure a database connection: localhost 3307 root admin.

C. . Right-click the et_telnet_tmpl and et_snmp_tmpl tables and choose Dump SQL File from the shortcut menu to back up the et_telnet_tmpl and et_snmp_tmpl tables.

D. Open the et_device table, open the asset import template, and enter IP addresses in the Device IP column in the template, and enter the SNMP template name and Telnet template name (can be found in et_telnet_tmpl and et_snmp_tmpl) corresponding to snmptmpl_id and telnettmpl_id in the snmp\telnet template in the asset template.

E. Uninstall and then re-install the SNC. Start navicat, restore the et_telnet_tmpl and et_snmp_tmpltables, and then import the edited asset template.