Move MariaDB Database(s) Between PCs

To move MariaDB database from one PC to another PC

This article will guide you to move MariaDB database(s) from one PC to another PC.

Backing Up MariaDB Database

  • On the existing PC, close all UnityIS services.
  • Open and log into HeidiSQL. Select the database and then right-click on it and select Export Database as SQL.
  • In the pop-up window, select your database on the left pan, and Drop and Create boxes for Database(s) and Table(s). Select 'Insert' for the data drop down field, so that data can also be exported.
  • Choose the output path for the export file and then click on 'Export' button.

Restoring Database On New PC

  • On the new PC open and log into HeidiSQL
  • Create and empty database by right clicking on the database server and then click on File➜Create New➜Database
  • Select the newly created database and then click on File➜Load SQL File...
  • Browse to the SQL file exported in the previous section.
  • Once the file is loaded into the query editor, you can execute the query to re-store the database.

Update UnityIS Configuration

  • Go to UnityIS installation directory and open up Configuration.exe to make sure that database connection are set properly and is pointing to the restored database.
  • Now open up UnityIS and change the PC name for all drivers to the new PC.
  • Update service account for all drivers services on the new PC.
  • Start the drivers to bring the controllers online.

For Azure IC2/IC4 Controllers

For IC2/IC4 controllers do these additional steps to bring them online on the new PC.

  • On the old PC grab the azure.pfx file from this location C:\Program Files (x86)\UnityIS\Drivers\
  • On the new PC, replace the azure.pfx file in C:\Program Files (x86)\UnityIS\Drivers\ folder with the one that was grabbed in previous step. You can rename the existing one to something else and paste the backup file.
  • Log into the IC2/IC4 controller, and under Host Comm, change the Host IP to reflect the new PC IP and click on 'Save' button.
  • Re-start the Azure driver and the controller should come online.
  • After the controller comes online, verify the date/time and test the controller by sending manual commands and/or presenting cards to readers.

Was this article helpful?