MariaDB MariaBackup commands

MariaBackup MariaDB commands

MariaBackup is a backup utility for MariaDB.

MariaDB backup and recovery using Mariabackup.

Full backup and incremental backups using Mariabackup and Mariabackup commands options.

mariabackup --backup --data-dir=/data/mariadb/ --target-dir=/data/backups

mariabackup --backup --target-dir=/data/backups --user=mariabackup --password=secret

mariabackup --backup --data-dir=/data/mariadb/ --target-dir=/data/backups --user=mariabackup --password=secret

mariabackup --binlog-info --backup

mariabackup --compress --backup

mariabackup --backup --compress --compress-threads=12 --compress-chunk-size=5M

mariabackup --compress --compress-threads=12 --backup

mariabackup --core-file --backup

mariabackup --backup --databases="example.table1 example.table2"

mariabackup --backup --databases="example" --databases-exclude="example.table1 example.table2"

mariabackup --backup --databases-file=main-backup

mariabackup --backup -h /var/lib64/mysql

mariabackup --backup --defaults-file-extra=addition-config.cnf --defaults-file=config.cnf

mariabackup --backup --defaults-file="config.cnf

mariabackup --backup --target-dir=/home/mysql/inc1/ --incremental-basedir=/home/mysql/backup/ --user=mariabackup --password=mypassword

mariabackup --backup --target-dir=/tmp/mariadb/backup/increment/ --incremental-basedir=/tmp/mariadb/backup/ --user=backupuser --password=backup123

mariabackup --prepare --target-dir=/mariadb/backup/

mariabackup --prepare --data-dir=/data/mysql/ --target-dir=/data/backups

mariabackup --prepare --data-dir=/data/mysql/ --target-dir=/data/backups --user=mariabackup --password=secret

mariabackup --prepare --target-dir=/home/mariadb/backup --incremental-dir=/home/mariadb/inc1

mariabackup --prepare --apply-log-only --target-dir=/tmp/mariadb/backup/

mariabackup --prepare --apply-log-only --target-dir=/tmp/mariadb/backup/ --incremental-dir=/tmp/mariadb/backup/increment/

mariabackup --close-files --prepare

mariabackup --prepare --apply-log-only --target-dir=/tmp/mariadb/backup/ --incremental-dir=/tmp/mariadb/backup/incrementNew/

mariabackup --innobackupex --apply-log

mariabackup --copy-back --target-dir=/mariadb/backup/

mariabackup --copy-back --data-dir=/data/mysql/ --target-dir=/data/backups

mariabackup --copy-back --force-non-empty-directories

mariabackup --move-back --target-dir=/var/mariadb/backup/

Related Articles: Percona Xtrabackup (full/incremental) Backup & Recovery