Su source:
Fai uno user ‘backup’ via Webmin
mariabackup –backup –target-dir=./bak –user=backup
mariabackup –prepare –target-dir=bak
Su Target:
service mariadb stop
mv /var/lib/mysql /var/lib/mysql-back
mariadb-backup –copy-back –target-dir=bak
chown -R mysql:mysql /var/lib/mysql
systemctl restart mariadb.service
Via Webmin dai i permessi allo user in modo che possa connettersi dalla rete.
Testing remote db
mysql -u zabbix -h ip.ip.ip.ip -p