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!
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. :)
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.
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?
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.
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!
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. :)
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.
Extremely helpful, thank you so much
Enjoyed the video, thank you for creating and sharing.
Hi, very clear tutorial, thank you. How about incremental backup and restore?
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?
Nice video. Can you also do a video on mysql failover? 😊
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!
Is this Mariadb backup only applicable to Mariadb database? Can we use for MySQL 8.0.30?
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.
nice man cave