1. intro

database server -> srv002
old server -> srv004
new server -> srv014

2. step by step

on srv004

ha core stop

on srv014

systemctl stop homeassistant.service

on srv002

mariadb -u root -pPassw0rd -e "set global max_allowed_packet=100*1024*1024;"
mariadb -u root -pPassw0rd -e "drop database if exists hadb014;"
mariadb -u root -pPassw0rd -e "create database hadb014;"
mariadb-dump -u root -pPassw0rd hadb004 | mariadb -u root -pPassw0rd hadb014
mariadb -u root -pPassw0rd -e "show databases;"
+--------------------+
| Database           |
+--------------------+
///
| hadb004            |
| hadb014            |
///
+--------------------+
on srv014
rsync -ai --delete srv004:config/ config/
sed -i s~"hadb004"~"hadb014"~ config/secrets.yaml
systemctl start homeassistant.service
systemctl enable --now ss-getstates.service
Tip use top and wait till the upgrade is done

3. aftercares

vi /etc/cid.conf
///
# rsync (srvbu)
rsyncserver="d01nas005"
rsyncuserid="cidusr"
rsyncpasswd="4627037737371605"
rsyncpath="/volume2/backup/ha/srv014/"
///
# homeassistant
hadbname="hadb014"
hadbserver="srv002.d01.net"
hadbuserid="root"
hadbpasswd="4627037737371605"
///
vi /root/.ssh/config
///
host d01nas005
  hostname nas005.d01.net
///

4. backup

Warning check the directories backup/ and .homeassistant/backups/ 
echo "/bin/ha-backup" >> /bin/cid-hourly

4.1. sma

Tip POR the inverter 
P?ssw0rd!

5. sonos card

refresh the browser cache

6. tailscale

curl -fsSL https://tailscale.com/install.sh | sh
systemctl stop tailscaled.service
rm -fr /var/lib/tailscale/
systemctl stop tailscaled.service
tailscale up