I need to move my Home Assistant ecosystem from an old to new hardware.
Actually running on Raspberry Pi 4 booting from SSD with Debian 11 and HA Supervised.
Want to move to a VM under Proxmox with HassOS operating system.
Creating a snapshoot on old hardware and restoring on new seems fine except for MariaDB database that become corrupted.
Database is big and I want to preserve it.
I suppose I could stop MariaDB addon and take a snapshot to get a non-corrupted snapshot but creating a snapshoot is very time-consuming on Pi. I also need to repeat the database migration several times in these days while I test several things. So even doing several times a sql dump is not viable. I would like a faster method because I can’t stop addon for hours every time.
Best approach, I think, could be using mariabackup possibly with replication among old and new host, but mariabackup
seems not installed in the addon.
I read about a file copy method of databases folder while engines are stopped, I’m was trying to do it but on HassOS data folder of but it’s not easy.addon_core_mariasb
seems unaccessible (or I don’t know how to access because the /mnt/data/supervisor
path seems not existing)
So what is a fast and safe way to move MariaDB database between old and new host?
There are already many topic on this issue I hope there is now a solution.