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 1m
- Notes on mysqldump 1m
- Scenario Setup 2m
- Scenario 1: Backup Single Database 1m
- Demo 1: Backup Single Database 3m
- Scenario 2: Backup Multiple Databases 1m
- Demo 2: Backup Multiple Databases 2m
- Scenario 3: Backup All Databases 1m
- Demo 3: Backup All Databases 1m
- Scenario 4: Backup Single Table 1m
- Demo 4: Backup Single Table 2m
- Scenario 5: Backup All Databases 1m
- Demo 5: Backup of Stored Procedure, Triggers, and Events 2m
- Various Backup Options 2m
- Summary 1m
- Introduction 1m
- Notes on MySQL Workbench 1m
- Demo: Backup Single Database 2m
- Demo: Backup Multiple Databases 1m
- Demo: Backup Individual Tables 3m
- Demo: Backup Routines and Events 2m
- Demo: Backup Database in Dump Folder 2m
- Demo: Restore Database From Single File 2m
- Demo: Restore Database From Dump Folder 2m
- Summary 1m
About the author
Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 21 years of hands-on experience. He holds a Master of Science degree and numerous database certifications. Pinal has authored 14 SQL Server database books and 45 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,500 database tech articles on his blog at https://blog.sqlauthority.com.