help mariabackup command
Hi, I have mariadb 10.3.4-MariaDB, i trying to backup with mariabackup command. i setup binlog in my.cnf
#>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.
#>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 | +-----------------------+-----------+ 5 rows in set (0.000 sec)
and also check currnet binlog location. it was good.
#>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.