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.
If you want to back up an MS SQL database to a file, follow these examples shown below:
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:
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
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.
Execute one of the following commands according to your situation:
SQLCMD.EXE -S HOST\ERASQL -d ERA_DB -E -Q "RESTORE DATABASE ERA_DB FROM DISK = N'
C:\USERS\ADMINISTRATOR\DESKTOP\
BACKUPFILE'"
SQLCMD.EXE -S HOST\ERASQL -E -Q "RESTORE DATABASE ERA_DB FROM DISK = N'
C:\USERS\ADMINISTRATOR\DESKTOP\
BACKUPFILE'"
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.
If you want to restore a MySQL database from a file, execute this command:
mysql --host HOST -u ROOTLOGIN -p ERADBNAME < BACKUPFILE