[KB6764] Migrate ESET Security Management Center from Windows Server to ESET Security Management Center Virtual Appliance


ESET business product in Limited Support status

This article applies to an ESET product version that is currently in Limited Support status and is scheduled to reach End of Life status soon.

For a complete list of supported products and support level definitions, review the ESET End of Life Policy for business products.

Upgrade ESET business products.

  • In order to migrate ESET Security Management Center (ESMC) Server from Windows Server to ESET Security Management Center Virtual Appliance (ESMC VA), you will need to back up the database from Windows Server and restore it into the ESMC Virtual Appliance


  • ESMC Server version 7.0 or newer with database running at MySQL Server.
  • ESMC Server database must use a default name “era_db” and username “root”.
Supported MySQL database

The following guide is only applicable to ESET Security Management Center running a supported MySQL database.


  1. Click here to download the ESET Security Management Center Virtual Appliance (ESMC VA) for your particular hypervisor type. Deploy the ESMC VA into your virtual environment, for further information regarding this process, review the VA Deployment support page. Do not configure the ESMC VA yet. After a successful deployment, follow the directions on the ESMC Virtual Appliance main screen to set a static IP address.
  2. On your existing Windows ESMC Server, create a new policy to set the new ESMC Server IP address and assign the policy to all client computers. Click PoliciesNew Policy.

Figure 1-1
Click the image to view larger in new window

  1. Enter a Name for your policy; the Description field is optional.

  2. Click the Settings tab, in the drop-down menu, select ESET Management Agent and click Edit server list.

Figure 1-2
Click the image to view larger in new window

  1. In the Servers window, click Add. In the Host field, type the IP address of your new ESMC VA. If you are using a different port, other than the default ESMC Server port 2222, specify your custom port number. Click OK. Make sure your new ESMC Server address is listed first and click Save.

Figure 1-3

  1. Click the Assign tab to specify the clients that are targeted by this policy. Click the Assign button to display a new popup window with all Static and Dynamic Groups.

Figure 1-4
Click the image to view larger in new window

  1. Select the Static Group All to assign a new policy and click OK.

Figure 1-5
Click the image to view larger in new window

  1. Review the settings for this policy and click Finish to apply. According to your ESMC Server settings, wait until the new policy is applied to agents.
  2. Stop the ESMC Server service.
  3. Create a full database backup of the source ESMC database. It is required that the ESMC database is named era_db. Name the backup file era-backup.sql. Open a Command prompt and navigate to the MySQL Server binaries folder (default location is C:\Program Files\MySQL\MySQL Server x.x\bin) and run the following commands:

a. Delete the contents of tbl_authentication_certificate table (otherwise, Agents may fail to connect to the new Server):

mysql.exe -u root -p -e "delete from era_db.tbl_authentication_certificate where certificate_id = 1";

b. Create a database backup:

mysqldump --host localhost --disable-keys --extended-insert --routines -u root -p era_db > era-backup.sql

  1. Return to the ESMC VA main screen. Press Enter to enter management mode, log in using the default password “eraadmin”, and press Enter twice to confirm.

Figure 1-6

  1. In the ESMC VA management mode menu, select Enable/Disable remote access to enable the Webmin interface.

  2. Connect to the Webmin interface using a web browser with an IP address of ESMC VA and port 10000. The address to connect should look like: https://xxx.xxx.xxx.xxx:10000
  3. Log into the Webmin interface using the default ESMC VA credentials where root is the login and eraadmin is the password.

Figure 1-7

  1. From the main menu, expand Others, select File Manager, and navigate to folder /root/.

Figure 1-8
Click the image to view larger in new window

  1. In the top right corner of File Manager, click File and select Upload to current directory.

Figure 1-9
Click the image to view larger in new window

  1. Click the Drag and drop files here and locate the era-backup.sql file you created in step 10. To upload the file, click Upload. When the upload is complete, log out of Webmin.

Figure 1-10

  1. In the ESMC VA main screen, log in to management mode. Select Restore database from the menu and press Enter. When the restoral of database backup is finished, press Enter to return back to the main screen.

Figure 1-11

  1. Configure the ESMC VA. Connect to the appliance using a web browser with an IP address of the ESMC VA. In the drop-down menu, select ESET Security Management Center Server Appliance.

Figure 1-12

  1. Set a new password for the VM. Select the check box I accept the terms of the application End User License Agreement and acknowledge the Privacy Policy. Click Submit to start ESMC VA configuration. Do not refresh this page in your web browser, close the tab and go to your ESMC VA console window.

Figure 1-13
Click the image to view larger in new window

  1. When the configuration is finished, log into the ESMC Web Console using the new password and verify the agents have migrated successfully and are connecting to the new server. Do not uninstall your old Windows ESMC Server until you have verified migration was successful.