migration the mariaDB from an existing one to another database name

1. intro

database server -> srv002
old name -> hadb014
new name -> hadb004

2. step by step

mariadb -h srv002 -u root -pPassw0rd -e "set global max_allowed_packet=100*1024*1024;"
mariadb -h srv002 -u root -pPassw0rd -e "drop database if exists hadb004;"
mariadb -h srv002 -u root -pPassw0rd -e "create database hadb004;"

systemctl stop homeassistant.service

mariadb-dump -h srv002 -u root -pPassw0rd hadb014 | mariadb -h srv002 -u root -pPassw0rd hadb004

sed -i s~"hadb014"~"hadb004"~ /etc/cid.conf
sed -i s~"hadb014"~"hadb004"~ /config/secrets.yaml

systemctl start homeassistant.service