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

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:
shawnp0wers.com
Check out my comic!
/ mybigroundworld
#linux #mysql #backup #mariadb #mysqldump #mariabackup

[@FireController1847]

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!

[@shawnp0wers]

I'm glad it helped! Backing up databases is always a worry of mine. I can back up files all the time, but databases are always in use, so it's... worrisome. :)

[@screamingiraffe]

Enjoyed the video, thank you for creating and sharing.

[@ynot4037]

Extremely helpful, thank you so much

[@eugenetsatskin5610]

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.

[@MrSnappyz]

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

[@kdub6400]

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?

[@DesChew]

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

[@shawnp0wers]

Should work exactly the same for mysql. I think there's a tool "mysqlbackup" instead of "mariabackup" -- but it should work the same. (If not, you could probably install mariabackup if your package manager wouldn't freak out over it going in without mariadb being installed. Behind the scenes it's pretty basic.)
NOTE: The above is not tested by me, just my gut instinct.

[@si_2ping_yun59]

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

[@shawnp0wers]

Yes! I want to also show load balancing along with high availability. It's not terribly difficult to set up, but makes scaling much easier!

[@DJConduct]

nice man cave