This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-16. For the latest, interactive version please visit https://mariadb.com/kb/.

mariabackup command question (binlog backup)

Hi, I have mariadb 10.3.4-MariaDB, i trying to backup with mariabackup command.

i setup binlog in my.cnf root>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. root>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_name File_size +-----------------------+-----------+ mariadb-binlog.000001 666 mariadb-binlog.000002 370 mariadb-binlog.000003 370 mariadb-binlog.000004 523 mariadb-binlog.000005 347 +-----------------------+-----------+

and also check currnet binlog location. it was good. root>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 Answered by Geoff Montee in this comment.

Mariabackup does not back up binary logs. See here:

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

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.