Migrate from Linux to Mac

I am currently using DigiKam on a Ubuntu Linux PC using the local MySQL Server on this machine. All collections (>100k photo and video files) and the database are on a SSD on this PC.
I use sidecar XMP files to store metadata for all RAW files and video files and I am only using the basic DigiKam functions for tagging and labeling (no RAW processing, editing or face recognition)
The Linux PC will be deprecated and I want to migrate everything to my Apple Mac mini. I have done some tests and it appears that DigiKam is working perfectly well on my Mac even with SQLite.
I have copied all collection folders from the Linux PC to the Mac and used Tools->Maintenance-> Sync Metadata and Database on the Mac to try to rebuild the database (now SQLite) from the metadata in the photo and XMP files. As far as I can tell most data has been recreated except for the group definitions (I have lots of groups for JPG-RAW combinations, panorama photos, time series etc.)
My questions:
- Can the group definitions be recovered from the Linux PC and added to the Mac?
- Are there other relevant features besides the group definitions that may not have been recreated from the metadata in the files?
- Was this a proper way to transfer everything from the Linux PC to the Mac or should I have used another method?