MariaDB - MariaBackup Explained | Reliable MariaDB Backup Script
This mariabackup tutorial will provide you with a short walkthrough of one of the primary physical mariadb backup tools.
As you will know from this sql tutorial for dummies, Mariabackup is an open-source tool to perform physical backups of InnoDB, MyISAM and Aria-based tables within MariaDB Server.
Starting from MariaDB 10.2.16 and MariaDB 10.3.8, Mariabackup can also back up data from the MyRocks storage engine.
Those running the InnoDB storage engine will benefit from hot online backups too.
Mariabackup supports features supported by Percona XtraBackup, comes with data at-rest encryption capabilities and support for InnoDB page compression. This MariaDB backup tool supports both Windows and Linux.
On Linux, Mariabackup can be installed by running one of these commands:
yum/dnf:
sudo yum install MariaDB-backup
apt-get:
sudo apt-get install mariadb-backup
zypper:
sudo zypper install MariaDB-backup
On Windows, Mariabackup comes pre-installed with MSI and ZIP packages.
You can invoke MariaBackup as-is or with one or more available options like so:
mariabackup [options]
Subscribe to this sql tutorial channel see available options!
Music:
Moonwalk by Jay Someday: / jaysomeday
Licensed under Creative Commons — Attribution 3.0 Unported — CC BY 3.0.
Free Download / Stream: https://tinyurl.com/ydfktbaa
Music promoted by Audio Library: https://tinyurl.com/3m5w8zt7
#shorts #reels #database #data #programming #mysql #mariadb