Difference between revisions of "Mariabackup"

From wikieduonline
Jump to navigation Jump to search
Tags: Mobile web edit, Mobile edit
 
(29 intermediate revisions by 2 users not shown)
Line 1: Line 1:
Mariabackup is a fork of Percona [[XtraBackup]] with added support for MariaDB 10.1 compression and data-at-rest encryption. It is included with [[MariaDB]] 10.1.23 and later.
+
{{lc}}
 +
<code>mariabackup</code><ref>https://mariadb.com/kb/en/mariabackup-overview/</ref> 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]]<ref>https://mariadb.com/kb/en/mariadb-10123-release-notes/</ref> (May 2017) and later.
  
Support full or incremental backups
+
Support full or [[incremental backups]]
 
https://mariadb.com/kb/en/incremental-backup-and-restore-with-mariabackup/
 
https://mariadb.com/kb/en/incremental-backup-and-restore-with-mariabackup/
  
 +
Support for online backups of [[InnoDB]], [[Aria]] and [[MyISAM]] tables.
  
==See also==
+
[[apt install mariadb-backup]]
*{{MariaDB}}
+
[[mariabackup --help]]
  
 +
== Examples ==
 +
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 ==
 +
* <code>[[mysqldump]]</code>
 +
* <code>[[show databases]]</code>
 +
* [[SST]]
 +
* <code>[[brew install mariadb]]</code>
 +
* [[MariaDB binary log]]: <code>[[mysqlbinlog]]</code>
 +
* [[--delete-master-logs]]
 +
 +
== Activities ==
 +
* Read announcement, May 2017:  https://mariadb.com/resources/blog/mariadb-backup-released-with-mariadb-server-10-1-23/
 +
 +
== See also ==
 +
* {{mariabackup}}
 +
* {{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: