I should have added in the show that there are scripts available to download the db and load the sql into a sqlite file.  This is probably a much easier option if you dont have experience managing mariadb.

The scripts are in the hpr_generator project:
https://repo.anhonesthost.net/HPR/hpr_generator/src/branch/main/utils

If you try the method in the show and are getting permission denied errors, try running the commands as root.   Sometimes the root user has blanket permissions to the databases. 