help mariabackup command

You are viewing an old version of this question. View the current version here.

Hi, I have mariadb 10.3.4-MariaDB, i trying to backup with mariabackup command. i setup binlog in my.cnf

  1. >cat /etc/my.cnf log_bin = /mariadb_data01/binlog/mariadb-binlog binlog_cache_size=100M max_binlog_size=200M expire_logs_days=4 binlog_format = mixed

And then, i trying to backup as below. after that backup has completed without any error.

  1. >mariabackup --defaults-file="/etc/my.cnf" --backup --target-dir /mariadb_back/backup/ --user root --password xxxxx i checked backup folder but binlog folder did not found.

and i check binnary logs either enable or disabled. it was good MariaDB [(none)]> show binary logs; +-----------------------+-----------+

Log_nameFile_size

+-----------------------+-----------+

mariadb-binlog.000001666
mariadb-binlog.000002370
mariadb-binlog.000003370
mariadb-binlog.000004523
mariadb-binlog.000005347

+-----------------------+-----------+ 5 rows in set (0.000 sec)

and also check currnet binlog location. it was good.

  1. >ls -al /mariadb_data01/binlog/ -rw-rw---- 1 mysql mysql 666 Feb 8 17:37 mariadb-binlog.000001 -rw-rw---- 1 mysql mysql 370 Feb 8 17:39 mariadb-binlog.000002 -rw-rw---- 1 mysql mysql 370 Feb 9 10:00 mariadb-binlog.000003 -rw-rw---- 1 mysql mysql 523 Feb 9 10:09 mariadb-binlog.000004 -rw-rw---- 1 mysql mysql 370 Feb 9 12:37 mariadb-binlog.000005 -rw-rw---- 1 mysql mysql 347 Feb 9 12:37 mariadb-binlog.000006 -rw-rw---- 1 mysql mysql 270 Feb 9 12:37 mariadb-binlog.index

Qustion: Therefore, How can i backup binlog folder with mariabackup command?

Answer

Mariabackup does not back up binary logs. See here:

https://mariadb.com/kb/en/library/files-backed-up-by-mariabackup/

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.