Difference between revisions of "Mariabackup"

From wikieduonline
Jump to navigation Jump to search
 
(5 intermediate revisions by 2 users not shown)
Line 33: Line 33:
 
* <code>[[show databases]]</code>
 
* <code>[[show databases]]</code>
 
* [[SST]]
 
* [[SST]]
 +
* <code>[[brew install mariadb]]</code>
 +
* [[MariaDB binary log]]: <code>[[mysqlbinlog]]</code>
 +
* [[--delete-master-logs]]
  
 
== Activities ==
 
== Activities ==
 
* Read announcement, May 2017:  https://mariadb.com/resources/blog/mariadb-backup-released-with-mariadb-server-10-1-23/
 
* Read announcement, May 2017:  https://mariadb.com/resources/blog/mariadb-backup-released-with-mariadb-server-10-1-23/
  
==See also==
+
== See also ==
 
* {{mariabackup}}
 
* {{mariabackup}}
* {{MariaDB}}
+
* {{DB backup}}
 
* {{Backups}}
 
* {{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: