Anthony Gerrard wrote:
We're setting a new Zope instance (2.10.7) using Relstorage (1.1.3) and MySql (5.0.77). We have 3 different mount points (main, Plone and temp) all pointing to different mysql databases.
I can't find any instructions about backing up this type of environment. Can just we back databases up sequentially?
Your main database probably changes very infrequently. No Plone user action should change the main database, so I suspect the backup order doesn't matter much. If both databases changed often, we'd have to think harder. For example, if you put your catalog in a different database, you would want to either back them up at the same instant (by shutting down, using a volume snapshot, or holding a lock on both databases for a short time) or back up the catalog first and plan to rebuild the catalog whenever you restore. Shane