I am about to replace a RPI3b with a brand new RPI4 for Home Assistant.
So far I have been using a MariaDB database on a Synology NAS due to the low performance and reliability of SQLite running on an SD Card.
With the new RPI4, which will be assembled on a Argon One M.2 case together with a 250GB SATA M.2 SSD, I want to run a local MariaDB that will keep all the history data.
My question is: what is the easiest way to copy data from the current DB to the new DB? Will a simple export/import via myphpadmin do the trick, or should I consider other options?