Everyone knows backups are important, but backing up MySQL and MariaDB databases is complicated, because you can't back up files while they're in use. And database files are ALWAYS in use!
Thankfully, there are multiple ways to make backups of MySQL and MariaDB databases, and once you know how, it's easy to integrate into your backup strategy as a whole. (You do have a backup strategy for all your files, right? RIGHT?!?)
SQL databases can be backed up using physical backups of the database files themselves, or using logical backups, which is an export of the databases using SQL commands. In this video we'll learn both methods of backup, and how to restore using both methods as well.
The good news is, it's really simple!
All My Online Homes are Here:
https://shawnp0wers.com/
Check out my comic!
https://twitter.com/MyBigRoundWorld
#linux #mysql #backup #mariadb #mysqldump #mariabackup
13 Comments