# Database Backup & Restore

## Agenda
1. Business Drivers & Terminology
- Data Protection Terminology
- Causes of data loss
- Business Drivers for backing up data
- Aligning Backup scope and frequency with SLA
- Classifying business data for backup
2. Backup & Restore Practices
- Backup Media & Tiering
- Backup Granularity
- Backup Availability
- Backup Rotation Scheme
- Backup Targets
- Backup Types & Methods
3. Backup Tools & Approaches
- MySQL Backup & Restore Tools
4. Database Backup and Restore - best practice recommendations

## References

[Richtlinie zur Datensicherung](https://github.com/Mrskos-SMP/policies/blob/main/06_Richtlinie%20zur%20Datensicherung.pdf)

[Making Backups with mariadb-dump - MariaDB Knowledge Base](https://mariadb.com/kb/en/making-backups-with-mariadb-dump/)

[How to Backup MySQL Database or Table (Ultimate Tutorial)](https://blog.devart.com/mysql-backup-tutorial.html)

[dbForge Studio for MySQL/MariaDB - MariaDB Knowledge Base](https://mariadb.com/kb/en/dbforge-studio-for-mysqlmariadb/)

[MySQL documentation: Backup and Recovery](https://dev.mysql.com/doc/refman/8.0/en/backup-and-recovery.html)

[MySQL Backup Solutions in 2021](https://www.percona.com/resources/videos/mysql-backup-solutions-2021)

[How to Back Up & Restore a MySQL Database](https://phoenixnap.com/kb/how-to-backup-restore-a-mysql-database)

[Database Backup and Recovery Best Practices](https://www.isaca.org/resources/isaca-journal/past-issues/2012/database-backup-and-recovery-best-practices)

[Backup and Recovery Best Practices](https://sqlbak.com/blog/backup-and-recovery-best-practices)

[Backup rotation scheme](https://en.wikipedia.org/wiki/Backup_rotation_scheme)

[The Cost of Lost Data](https://gbr.pepperdine.edu/2010/08/the-cost-of-lost-data/)