How To: Migrate PhotoPrism DB from SQLite to MariaDB on FreeBSD

Just a guide on how I got MariaDB working instead of SQLite for my PhotoPrism instance running on a FreeBSD jail.