Restore mariadb into addon from another source

For some time I have been running my recorder in mariadb hosted on another server.

To reduce co-dependency with this other server, I want to move to running mariadb as an addon on my NUC.

What is the best way to backup and restore my data? I can create a mysqldump of the current server easily enough but do not know enough about how the addons work to restore it. (where to copy the data to, and how to run mysqldump)

Please note, the backup is about 6GB so is far too large to restore through phpmyadmin.

Answering my own question for anyone else who comes across this thread.

The solution can be found here: