Course info

Rating

(113)

Level

Intermediate

Updated

May 24, 2014

Duration

1h 15m

Description

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.

Section Introduction Transcripts

IntroductionHi this is Pinal Dave and welcome to my MySQL Backup and Recovery Fundamentals course. Database concepts are considered as dry subject. I promise to make backup and recovery subject as interesting as possible. We all want to be happy and wish there are no problems in our life. We want to see lush green plains, soothing blue seashore, kids growing with nature, and a digital life where there are no disasters. In other words, we want perfect world. In reality the world is not perfect. Disaster happens and things can go wrong many ways, sometimes they are intentional and often they are not intentional. However, the reasons are always not pleasant. With reference to the database I often see developers forgetting something like this. They accidentally drop table and do not have any backup. They want to audit database which existed quite a while ago, sometimes they have a backup and they do not know how to restore it, and sometimes they are just disaster when something bad happens and they do not have data or database backup. Well excellent, disaster and human errors are going to be there always. In addition to that, there are some valid business cases when none of the above has happened, but we need to recover or restore our database in its previous original state. In this course we are precisely going to learn how to take efficient backup and recover your database by restoring it to its original state.

Backup With mysqldumpHi this is Pinal Dave and welcome to the module of Backup with mysqldump. Let us see what we are going to cover in this module. First we will understand the basics of mysquldump. Right after that we will set up the scenario which we will use to explain various concepts of the mysqldump in this module. Later in this module we will understand how to take backup of single database, multiple databases, as well as all databases. There are quite a few instances when _____ has to take backup of a single table. We will cover that specific scenario in this module as well. Before we complete this demo we will also talk about how to backup various objects like stored procedures, triggers, and events with the help of mysqldump. It is extremely important to understand how mysqldump works for anybody who loves their data.

Restore With mysqlHi this is Pinal Dave and welcome to the module of Restore with mysql command. In earlier module we learned how to take backup with the help of mysqldump command and now in this module we will restore the same backup with the help of mysql command. Let's see what we are going to cover in this module. First we will have introduction to the syntax, right after that we will understand scenario setup for the demonstration. Scenario of this module is very similar to previous model scenario. We will help company set up in two different countries. Right after that, we will see demonstration where we will restore a single database and before the module ends we will see a demonstration of restoring multiple databases. Finally, we will have summary in 60 seconds.

Data Export and Import With WorkbenchHi this is Pinal Dave and welcome to the module of Data Export and Import with MySQL Workbench. Let's see outline of what we're going to cover in this module. First we'll have introduction to MySQL Workbench and right after that we will see how we can export data with MySQL Workbench. We will see various options as well as cool tricks about data export. Following that you will understand how to import data with the help of MySQL Workbench. And finally we will have summary of what we have learned. Remember this is not a course to learn MySQL Workbench. If you are interested to learn about MySQL Workbench, I have already built a course explaining various features of MySQL Workbench in Pluralsight library. The name of the course is MySQL Workbench Guided Tour. It covers three important aspects of MySQL Workbench as well as explains many efficiency tips and tricks to use MySQL Workbench. In this module we are going to focus on data export and data import, features of MySQL Workbench.

Frequently Asked QuestionsHi, this is Pinal Dave and welcome to the module of Frequent Asked Questions. Whenever I talk about mysql backup and restore and I often get lots of questions. I have selected five of the most frequently asked questions and will be discussing them in this module. First, we will discuss about point in time recovery. Right after that we'll discuss topics like frequency of backup, location of backup, as well as how to copy database from one server to another. And finally, we will discuss best time of the day for backup and restore. Let's start with our very first scenario of point in time recovery.