Difference between revisions of "Mariabackup"

From wikieduonline
Jump to navigation Jump to search
 
(3 intermediate revisions by the same user not shown)
Line 34: Line 34:
 
* [[SST]]
 
* [[SST]]
 
* <code>[[brew install mariadb]]</code>
 
* <code>[[brew install mariadb]]</code>
 +
* [[MariaDB binary log]]: <code>[[mysqlbinlog]]</code>
 +
* [[--delete-master-logs]]
  
 
== Activities ==
 
== Activities ==
Line 41: Line 43:
 
* {{mariabackup}}
 
* {{mariabackup}}
 
* {{DB backup}}
 
* {{DB backup}}
 +
* {{Backups}}
  
 
[[Category:MariaDB]]
 
[[Category:MariaDB]]

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

Examples[edit]

Full:

mariabackup --backup \
  --target-dir=/var/mariadb/backup/ \
  --user=mariabackup --password=mypassword

Incremental

mariabackup --backup \
  --target-dir=/var/mariadb/inc1/ \
  --incremental-basedir=/var/mariadb/backup/ \
  --user=mariabackup --password=mypassword


parallel=#
--prepare


Related terms[edit]

Activities[edit]

See also[edit]

  • https://mariadb.com/kb/en/mariabackup-overview/
  • https://mariadb.com/kb/en/mariadb-10123-release-notes/
  • Advertising: