How to backup Wordpress with MariaDB

This video is a tutorial on how to properly back up your website data, by using Wordpress as an example. We will not just show a simple how-to guide, but also explain the fundamentals and different options available when trying to take a backup. You will need a few linux terminal skills to get through this, but all the commands are explained in detail. After watching this video, you will understand the trade-offs of each approach and also see a step-by-step guide for taking a physical backup using mariadb-backup.

0:00 Start

Part 1: Theory behind back-ups
0:22 Why do backups
3:15 Backup options (Cluster, Replication)
4:53 Snapshot backups (Logical vs Physical)
5:23 mariadb-dump – Logical backup tool
6:44 mariadb-backup – Physical backup tool

Part 2: Back up a live website
8:06 Understanding what is going on behind the scenes
9:43 Installing mariadb-backup
10:46 Requirements for taking a backup
11:18 Creating a backup user
12:25 Taking the backup
14:20 Examining our backup
15:02 Recreating a disaster scenario
16:04 Restoring the backup
20:24 Summary of steps to take

Links:
* Mariabackup – https://mariadb.com/kb/en/mariabackup/

Music:

“Jellyfish in Space” Kevin MacLeod (incompetech.com)
Licensed under Creative Commons: By Attribution 4.0 License
http://creativecommons.org/licenses/by/4.0/