[KB6725] Create a backup of the ESET Security Management Center database (7.x)

Details

ESET business product no longer supported

This content applies to an ESET product version that is currently in End of Life status and is no longer supported. This content is no longer updated.

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.

All ESET Security Management Center (ESMC) information and settings are stored in the database. We recommend that you create regular database backups to ensure the security of your data in the event of an emergency. Refer to the appropriate section for your database type.

Solution

MS SQL | MySQL

The backup can be used later

The backup can also be used later when migrating ESET Security Management Center to a new server.

MS SQL Backup examples

If you want to back up an MS SQL database to a file, follow these examples shown below:

Illustrated examples are with default settings

These examples are intended for use with default settings (for example, default database name and database connection settings). Your backup script will need to be customized to accommodate any changes you have made to default settings.

One time database backup
Open a Windows command prompt and type the following command to create a backup file named BACKUPFILE:

SQLCMD -S HOST\ERASQL -Q "BACKUP DATABASE ERA_DB TO DISK = N'BACKUPFILE'"

HOST - IP address or hostname
ERASQL - name of the MS SQL server instance

Regular database backup with sql script
Choose one of the following SQL scripts:

Create regular backups and store them based on date of creation:

1. @ECHO OFF
2. SQLCMD.EXE -S HOST\ERASQL -d ERA_DB -E -Q "BACKUP DATABASE ERA_DB TO DISK = N'BACKUPFILE' WITH NOFORMAT, INIT, NAME = N'ERA_DB', SKIP, NOREWIND, NOUNLOAD, STOP_ON_ERROR, CHECKSUM, STATS=10" 3. REN BACKUPFILE BACKUPFILE-[%DATE:~10,4%%DATE:~4,2%%DATE:~7,2%_T%TIME:~0,2%%TIME:~3,2%].bac

Append your backup to a file:

1. @ECHO OFF 2. SQLCMD.EXE -S HOST\ERASQL -d ERA_DB -E -Q "BACKUP DATABASE ERA_DB TO DISK = N'BACKUPFILE' WITH NOFORMAT, NOINIT, NAME = N'ERA_DB', SKIP, NOREWIND, NOUNLOAD, STOP_ON_ERROR, CHECKSUM, STATS=10"

For more information on Microsoft SQL Server backup see the following Microsoft Knowledge Base article.

MS SQL restore

Execute one of the following commands according to your situation:

To restore an MS SQL database from a file on an environment with existing ERA_DB database, execute this command:

SQLCMD.EXE -S HOST\ERASQL -d ERA_DB -E -Q "RESTORE DATABASE ERA_DB FROM DISK = N'C:\USERS\ADMINISTRATOR\DESKTOP\BACKUPFILE'"

To restore an MS SQL database from a file on an environment without existing ERA_DB database, execute this command:

SQLCMD.EXE -S HOST\ERASQL -E -Q "RESTORE DATABASE ERA_DB FROM DISK = N'C:\USERS\ADMINISTRATOR\DESKTOP\BACKUPFILE'"

MySQL backup

If you want to create a backup a MySQL database to a file, follow these examples shown below:

mysqldump --host HOST --disable-keys --extended-insert --routines -u ROOTLOGIN -p ERADBNAME > BACKUPFILE

HOST - IP address or hostname of MySQL server
ROOTLOGIN - the root account of MySQL server
ERADBNAME - ESMC database name

For more information on MySQL Server backup visit MySQL documentation website.

MySQL restore

If you want to restore a MySQL database from a file, execute this command:

mysql --host HOST -u ROOTLOGIN -p ERADBNAME < BACKUPFILE

Last Updated: Sep 30, 2022