-
Course
- Data
MySQL Backup and Recovery Fundamentals
MySQL course focusing on Backup and Recovery of the MySQL Server.
What you'll learn
Data is very important to any application and business. It is very important that every business plan for data safety. Database backup strategies are often discussed after the disaster has already happened. In this introductory course we will explore a few of the basic backup strategies every business should implement for data safely. We will explore how we can recover our server quickly after any unfriendly incident to our MySQL database.
Table of contents
- Introduction | 56s
- Notes on mysqldump | 1m 6s
- Scenario Setup | 1m 34s
- Scenario 1: Backup Single Database | 49s
- Demo 1: Backup Single Database | 3m 17s
- Scenario 2: Backup Multiple Databases | 1m 11s
- Demo 2: Backup Multiple Databases | 1m 52s
- Scenario 3: Backup All Databases | 1m 6s
- Demo 3: Backup All Databases | 1m 14s
- Scenario 4: Backup Single Table | 1m 4s
- Demo 4: Backup Single Table | 2m
- Scenario 5: Backup All Databases | 1m 17s
- Demo 5: Backup of Stored Procedure, Triggers, and Events | 2m 13s
- Various Backup Options | 1m 42s
- Summary | 43s