C:\Program Files\MySQL\MySQL Server x.x\bin
). Type the following commands, replace TARGETHOST
with the address of the target database server.mysql --host TARGETHOST -u root -p "--execute=CREATE DATABASE era_db /*!40100 DEFAULT CHARACTER SET utf8 */;"
Restore the ESET PROTECT VA backed up database to the previously prepared empty database. Make PATHTOBACKUPFILE
the location where you have stored the ESET PROTECT VA database backup:
mysql --host TARGETHOST -u root -p era_db < PATHTOBACKUPFILE
root
on the target MySQL server. Replace TARGETERAPASSWD
with the password you used to log in to ESET PROTECT VA management console:
mysql --host TARGETHOST -u root -p "--execute=CREATE USER root@'%' IDENTIFIED BY 'TARGETERAPASSWD';"
- root
, on the target MySQL server:mysql --host TARGETHOST -u root -p "--execute=GRANT ALL ON eradb.* TO root;"
Remove all records from the tbl_authentication_certificate table (if you do not remove these records, Agents may fail to connect to the new ESET PROTECT Server):
mysql --host TARGETHOST -u root -p "--execute=DELETE FROM era_db.tbl_authentication_certificate where certificate_id = 1;"