Hey @timbutler,
Thanks for the detailed explanation.
I would suggest yet another alternative which is to plug the system-backup interface which gives read access to all of the host filesystem, via /var/lib/snapd/hostfs (i.e. /var/lib/snapd/hostfs/var/lib/mysql)
Hopefully this works!