MySQL Error 1067: Process Terminated Unexpectedly
Introduction
MySQL Server is a server that is stored the Ingress Software database. The MySQL services are required to be run for the Ingress Software to function well. Due to the services of MySQL being unable to run, this error will cause the Ingress Software to not work as it is unable to connect to its database which resides at MySQL Server. Several troubleshooting steps are required and most of the time reinstallation of MySQL most likely needs to be done.
However, reinstallation of MySQL will clear up the database on Ingress. So, you are required to have a backup database that has been made previously so we can restore the database. If you do not have any backup database then you might need to start setting up the software again from the beginning. That is the importance of a backup database and we highly recommend at least making a backup database once per month so we can restore it in case of this issue is happening.
For the initial troubleshooting, you may try the following steps. Please make sure to log into your Windows account by using the Administrator login first before proceeding with the following steps.
1. Go to Control Panel > Administrative Tools
2. Go to Services
3. Find MySQL Services > Right Click and select Properties
4. Click Stop > Click OK
5. Go to C:\ProgramData\MySQL\MySQL Server 5.5\data (Please note that the ProgramData folder is hidden, you need to tick “Show hidden folder” to view this folder)
6. Find ib_logfile0 and ib_logfile1, and then delete them.
7. Go to the Services window and try to start the MySQL service again.
If the MySQL services are still unable to run, then the only solution is to reinstall MySQL. Kindly refer to the following step.
1. Go to Control Panel > Program & Features
2. Uninstall MySQL Server and Ingress.
3. Delete Mysql Folder at C:\Program Files\MySQL
4. Delete Mysql Folder at C:\ProgramData\MySQL (Please note that the ProgramData folder is hidden, you need to tick “Show hidden folder” to view this folder)
5. Run the Ingress Software installer. You may download the installer from the following link: https://www.fingertec.com/softwareupdate/ingress/software-ingress_download_e.html
6. Complete all installation steps as per explain in the link: https://www.fingertectips.com/2022/08/complete-guide-on-how-to-install.html
7. Once installed, if you have the backup database, you may restore it back but if you do not have the backup database then you will need to start a fresh setup of the software. For the steps to restore the database, please refer link: https://www.fingertectips.com/2016/03/backup-and-restore-database-management.html
Related Articles
MySQL services unable to run started and then stopped error
MySQL services unable to run: Started and then stopped error MySQL Server is a server that stores the Ingress Software database. MySQL service is required to run for the Ingress Software to function well. Since the MySQL service was unable to run (as ...Resolve “Failed to initialize database connection” error message in Ingress MySQL
Introduction Whenever a user launches the Ingress MySQL software, an error message “Failed to Initialize Database Connection” will appear. This error message occurs due to the service reboot every time you shut down your PC. The following tips ...How to Fix Insert User ID and Username Error for Ingress (MySQL)
Introduction In Ingress MySQL, a feature named ‘Database Initialization’ can initialize the Attendance module whereby the system will remove all relevant tables data, including clocking schedule and group duty roster. And this will lead to the error ...How to Solve “Load Default Device Detail Error” in Ingress Software (MySQL)
Introduction There was feedback from Ingress Software users about ‘Load Default Device Detail Error’. This error is prompted when the user clicked on Device tab, and it has caused missing clocking data in Ingress software and the user is not able to ...How to Solve the Failed to Upgrade Database Error in Ingress MySQL Software
Introduction Whenever a user is unable to launch Ingress software, it will require you to run Ingress DB Installer to connect the software with the database again and complete the steps Test Connection > Update Connection > Upgrade Database. ...