# Docker

**Migration from 3.10 (or less) to 3.11 (or up) requires additional steps because we have significantly improved the data protection mechanism - now it is built on certificates and doesn't require entering the password manually on server start. Please follow these steps to update your HES:**

1. Update all Hideez Clients to 3.16.X, the new version can work with both old and new versions of the HES.
2. Disable the Data Protection on the HES.
3. Update the server using the following instruction.
4. Enable Data Protection again.

#### Create folder for backup

```
sudo mkdir /opt/HES.old
```

Backup the Database (Optimal (for possible further recovery)):

* MySQL Database:

The following command will create a copy of the database (dump) in file hesdb.sql in `/opt/HES.old` directory (on host) from container with name `hes-mysql`:

```
cd /opt/HES/
sudo sh -c "docker exec hes-mysql /usr/bin/mysqldump -u root --password=password hesdb > /opt/HES.old/hesdb.sql"
```

* MS SQL Database:

The following command will create a backup of the database  hesdb in file hesdb.bak in `/opt/HES/mssql/data/` local directory:

```
cd /opt/HES/
sudo docker exec -it hes-mssql  /opt/mssql-tools18/bin/sqlcmd -S localhost -U SA -P "C00ll_Passwrd_here"  -Q "BACKUP DATABASE [hesdb] TO DISK = N'/var/opt/mssql/data/hesdb.bak' WITH NOFORMAT, NOINIT, NAME = 'db-full', SKIP, NOREWIND, NOUNLOAD, STATS = 10"
```

instead of "C00ll\_Passwrd\_here", enter your password here, which you specified in the `/opt/HES/docker-compose.yml` file

### Stop containers:

```
cd /opt/HES/
sudo docker compose down
```

(Optimal) Save the image of HES to a tar file (for possible further recovery):

```
sudo docker save -o /opt/HES.old/hes.tar hes
```

### Remove image of HES:

```
sudo docker rmi hes --force
```

To upgrade the server to the latest version, run commands:

```
sudo docker build . -t hes
```

and Restart containers:

```
sudo docker compose up -d
```

### If something goes wrong, you can restore the HES server using the following commands:

Stop containers:

```
cd /opt/HES/
sudo docker compose down
```

Remove image of HES:

```
sudo docker rmi hes --force
```

Restore the Database

* My SQL:

Start MySQL container only:

```
sudo docker compose up -d hes-mysql
```

Restore the MySQL Database from dump file:

```
sudo cat /opt/HES.old/hesdb.sql | sudo docker exec -i hes-mysql /usr/bin/mysql -u root --password=password hesdb
sudo docker compose down 
```

* MS SQL:

Start MS SQL container only:

```
sudo docker compose up -d hes-mssql
```

Restore the MS SQL Database from bak file:

```
cd /opt/HES/
sudo docker exec -it hes-mssql /opt/mssql-tools18/bin/sqlcmd -S localhost -U SA -P "C00ll_Passwrd_here"  -Q "RESTORE DATABASE [db] FROM DISK = N'/var/opt/mssql/data/hesdb.bak' WITH FILE = 1, NOUNLOAD, REPLACE, STATS = 5"
```

instead of "C00ll\_Passwrd\_here", enter your password here, which you specified in the `/opt/HES/docker-compose.yml` file

Restore old image of HES from tar file:

```
sudo docker load -i /opt/HES.old/hes.tar
```

and start containers:

```
sudo docker compose up -d
```

### After checking that the update was successful and everything works fine, you can delete copies of the database and server:

```
$ sudo rm -rf /opt/HES.old
```