Troubleshooting Guide – Resolve blank device and user tab when restoring Ingress MySQL database into a new PC
Introduction
Under some circumstances, you might bump into several issues with your computer till you need to reinstall the software into another PC, and require restoring the old backup database. At times, some users experience a blank device or user after the restoration. In this article we will guide you on how resolve blank user or device tab after restoring an old Ingress MySQL database in a new PC
1) Install the latest Ingress software and restore the Ingress MySQL database by using SQLYog
https://www.fingertectips.com/2015/11/backuprestore-ingress-database-using_26.html (refer backup steps )
Please download the MySQL Manager tool from the link below:
SQLyog installer (64-bit operating system)
https://s3.amazonaws.com/SQLyog_Community/SQLyog+12.2.1/SQLyog-12.2.1-0.x64Community.exe
SQLyog installer (32-bit operating system)
https://s3.amazonaws.com/SQLyog_Community/SQLyog+12.2.1/SQLyog-12.2.1-0.x86Community.exe
2) After software login, you might find the user and device tab is blank.
Thus, you may follow the steps given below to resolve the issue
A) Please close all application
B) Restart MySQL, Ingress Service, Ingress WDMS Service and Attendance Service (Task Manager > Services > restart all the respective services )
C) Run Ingress DB Installer
FingerTec Ingress folder (Ingress server folder in C drive ) > Ingress DB Installer > Key In MySQL > Test Connection > Update Connection > Reset Upgrade > DB Diagnostic > DB Maintenance > Upgrade Database
4) Open Ingress > login. You should be able to view the users and devices in the Ingress software.
Related Articles
Troubleshooting on Ingress DB Installer for Ingress software (MySQL database)
Introduction Ingress DB Installer is the Ingress connector tool that we use to establish the connection between Ingress program and MySQL server 5.5 database program. Sometimes, users may face problems loading the Ingress software. For example, the ...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 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 ...6 Things You Need to Know about Ingress MySQL Database
Introduction If you have some or absolutely no idea about MySQL database and how it works with Ingress, this is the right article for you to explore. It is well understood that by now there are countless articles written about MySQL database, and ...Troubleshooting Guide - Unable to Download User Data from AWDMS into Ingress Software
Introduction Since we have introduced new Face ID5 devices, there is a certain issue expressed by clients when they are managing their system and user data on the Ingress software and AWDMS program. One of these issues is that they cannot download ...