Flesh out docs on backups
Created by: seancolsen
Two people have asked recently in Mattermost how to backup CiviCRM.
We now have this page on backups in the Sysadmin Guide, but it could use some work.
This page would benefit from the following:
- More instructions for running
mysqldump
- Instructions for making backup through phpMyAdmin
- Clarify the importance of setting up automated backups.
- Recommendations for off-site backup services to use.
- What options are important to enable/disable when making DB backups. E.g. Triggers? Drop tables?
- Should you lock tables when making backups? Discuss potential performance and atomicity issues with both approaches.
- Mention mydumper as an alternative to
mysqldump
. - Instructions for restoring, and the importance of restoring your backups to a test instance periodically (e.g. during upgrades) as a mechanism to test that your backups are working correctly.
- Maybe more? It would be great if others could give this page a look and see if it could use other info. Tagging @bgm and @MegaphoneJon because I know you two know a lot on this topic!