From the course: Advanced MySQL Database Administration
Join today to access over 24,700 courses taught by industry experts.
Solution: Backup and recovery - MySQL Tutorial
From the course: Advanced MySQL Database Administration
Solution: Backup and recovery
- [Instructor] All right, this is the Solution Video for your assignment on Backup & Recovery. As a reminder, Sally's coming to you because she wants you to put together a formal backup and recovery plan. Ideally, your plan should include talking about some of the risks that might happen. Data risks could range from an external malicious attack, an angry employee, something unintentional that one of your employees did to accidentally delete the data. There could be a hardware malfunction. So, there's a number of things that could happen with the data. It's important at least that you understand those risks, and can vocalize them to a stakeholder. In this case, Sally is coming to you looking for a proposal, but sometimes you need to be able to advocate for that to a stakeholder on your own. So, understanding those possible risks can really help with that. Next, in your proposal, hopefully you've talked about having some form of replication for your master server, so setting up a mirror…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.