2014
pluralsight
Pinal Dave
1h 15m
English

MySQL course focusing on Backup and Recovery of the MySQL Server.

1. Introduction
Introduction
Course Outline
2. Backup With mysqldump
Introduction
Notes on mysqldump
Scenario Setup
Scenario 1: Backup Single Database
Demo 1: Backup Single Database
Scenario 2: Backup Multiple Databases
Demo 2: Backup Multiple Databases
Scenario 3: Backup All Databases
Demo 3: Backup All Databases
Scenario 4: Backup Single Table
Demo 4: Backup Single Table
Scenario 5: Backup All Databases
Demo 5: Backup of Stored Procedure, Triggers, and Events
Various Backup Options
Summary
3. Restore With mysql
Introduction
Notes on Restore
Script for Backup and Restore
Scenario Setup
Scenario 1: Restore Single Databases
Demo 1: Restore Single Databases
Scenario 2: Restore Multiple Databases
Demo 2: Restore Multiple Databases
Summary
4. Data Export and Import With Workbench
Introduction
Notes on MySQL Workbench
Demo: Backup Single Database
Demo: Backup Multiple Databases
Demo: Backup Individual Tables
Demo: Backup Routines and Events
Demo: Backup Database in Dump Folder
Demo: Restore Database From Single File
Demo: Restore Database From Dump Folder
Summary
5. Frequently Asked Questions
Introduction
Point in Time Recovery
Demo: Point in Time Recovery With Log File Edit
Demo: Point in Time Recovery With Timestamp
Frequency of Backup
Location of Backup
Copy Database From One Server to Another
Best Time of the Day for Backup and Restore
Final Note

Download File Size:193.06 MB

---