Difference between revisions of "Mariabackup"
Jump to navigation
Jump to search
↑ https://mariadb.com/kb/en/mariabackup-overview/
↑ https://mariadb.com/kb/en/mariadb-10123-release-notes/
Line 35: | Line 35: | ||
* <code>[[brew install mariadb]]</code> | * <code>[[brew install mariadb]]</code> | ||
* [[MariaDB binary log]]: <code>[[mysqlbinlog]]</code> | * [[MariaDB binary log]]: <code>[[mysqlbinlog]]</code> | ||
+ | * [[--delete-master-logs]] | ||
== Activities == | == Activities == |
Latest revision as of 12:55, 19 February 2023
mariabackup
[1] is a fork of Percona XtraBackup with added support for MariaDB 10.1 compression and data-at-rest encryption. It is included as alpha version with MariaDB 10.1.23[2] (May 2017) and later.
Support full or incremental backups https://mariadb.com/kb/en/incremental-backup-and-restore-with-mariabackup/
Support for online backups of InnoDB, Aria and MyISAM tables.
apt install mariadb-backup mariabackup --help
Contents
Examples[edit]
Full:
mariabackup --backup \ --target-dir=/var/mariadb/backup/ \ --user=mariabackup --password=mypassword
mariabackup --backup \ --target-dir=/var/mariadb/inc1/ \ --incremental-basedir=/var/mariadb/backup/ \ --user=mariabackup --password=mypassword
parallel=#
--prepare
Related terms[edit]
mysqldump
show databases
- SST
brew install mariadb
- MariaDB binary log:
mysqlbinlog
- --delete-master-logs
Activities[edit]
- Read announcement, May 2017: https://mariadb.com/resources/blog/mariadb-backup-released-with-mariadb-server-10-1-23/
See also[edit]
mariabackup, mariabackup --help, mysqlbinlog
, MariaDB binary log,max_binlog_size
, PITR- Database backups:
mariabackup, mysqldump
,mongodump
,mariabackup, pg_dump
- Backups: Data corruption, Business continuity planning, Bacula, Commvault, NetBackup, Veeam, Storage Lifecycle Policy (SLP), TeamCity backup, Backup docker containers, HP Data Protector, Unitrends, Acronis, Veeam Backup & Replication, Disaster Recovery (DR), Point-in-time recovery, RTO, RPO, PITR, Rewind
Advertising: