If you use an addon database like MariaDB you can unselect it in partial snapshots.
As for automating: