What is stored
On macOS, the default database is
~/Library/Application Support/mains/mains.db. Files such as attachments, collection sources, and Atlas copies also live alongside it.
Backing up only the database does not preserve those file bytes. Stop the backend before making a complete data-directory backup.
