Back Up Your MySQL Databases! (Spoiler: It's Easy)

preview_player
Показать описание
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:

Check out my comic!

#linux #mysql #backup #mariadb #mysqldump #mariabackup
Рекомендации по теме
Комментарии
Автор

This was really helpful. Tried this tool for the first time today and didn’t realise you could do the prepare up front. Thanks!

bballantyne
Автор

Incredibly useful video! Thank you for showing me mariabackup, this is super helpful! It's oddly difficult to find information explaining how to take backups of large-data databases, so discovering this and heading over to their docs helped a ton!

FireController
Автор

Found it useful, thank you!
Also it would be great to have an automation script which makes backup and removes the old one which is ~2 weeks older or smth like that.

eugenetsatskin
Автор

Hi, very clear tutorial, thank you. How about incremental backup and restore?

MrSnappyz
Автор

Great video. How would you do a full backup of a fairly large (100GB) database using mysqldump? Also is it possible to just have one file or file name?

kdub
Автор

Is this Mariadb backup only applicable to Mariadb database? Can we use for MySQL 8.0.30?

DesChew
Автор

Enjoyed the video, thank you for creating and sharing.

screamingiraffe
Автор

Nice video. Can you also do a video on mysql failover? 😊

si_ping_yun