Table of Contents
Shifting your FingerTec Ingress software from a Microsoft Access Database (MDB) to a MySQL Database is highly recommended if your database is approaching its 2GB storage limit, or if you need to support newer devices natively (like the Face ID 5, Face ID 6, or Kadex+).
The official transition path provided by FingerTec requires a database conversion process:
1. Back Up and Convert Your Existing Data #
Because MDB and MySQL use entirely different database structures, you cannot simply copy and paste the file.
- Open your current Ingress MDB software.
- Go to System Settings > Database Configuration > select Backup to save a copy of your existing data.
- Email your backup file to support@fingertec.com. The FingerTec support team will manually convert your .mdb database into a MySQL-compatible .sql format and return it to you.
2. Prepare and Install Ingress MySQL #
While waiting for your converted database file, prepare your computer for the MySQL edition:
- Download the correct installer: Download the dedicated Ingress MySQL installation bundle from the official FingerTec Download Page.
- Install MySQL Server: Run the setup. The installation wizard will guide you through installing the MySQL components. Make sure to enable TCP/IP networking (default port 3306) and Strict Mode.
- Set a Root Password: Create a strong root password during setup (write this down, as you will need it to connect the software).
3. Connect and Restore Your Data #
- Launch the Ingress DB Installer utility that comes with the new installation.
- Enter your MySQL username (root) and the password you created during setup, then click Test Connection.
- Once connected, select Update Connection to finalize the link.
- To bring back your old data, take the converted file sent back by FingerTec support, go to the database utility or System Settings, and use the Restore function to import it into your new MySQL environment.
Credit By : Webstation
