Comments - Mariabackup Overview

3 years, 10 months ago Doan Dung

I have a problem when I backup as below, I can not backup with mariabackup command:

mariabackup --backup --target-dir=/data/sms_replicate/ --datadir=/var/lib/mysql/ -u root --password=** [00] 2020-05-27 08:53:56 Connecting to MySQL server host: localhost, user: root, password: set, port: not set, socket: not set [00] 2020-05-27 08:53:56 Using server version 10.3.8-MariaDB-log mariabackup based on MariaDB server 10.3.23-MariaDB Linux (x86_64) [00] 2020-05-27 08:53:56 uses posix_fadvise(). [00] 2020-05-27 08:53:56 cd to /var/lib/mysql/ [00] 2020-05-27 08:53:56 open files limit requested 0, set to 65536 [00] 2020-05-27 08:53:56 mariabackup: using the following InnoDB configuration: [00] 2020-05-27 08:53:56 innodb_data_home_dir = [00] 2020-05-27 08:53:56 innodb_data_file_path = ibdata1:12M:autoextend [00] 2020-05-27 08:53:56 innodb_log_group_home_dir = ./ [00] 2020-05-27 08:53:56 InnoDB: Using Linux native AIO 2020-05-27 8:53:56 0 [Note] InnoDB: Number of pools: 1 [00] 2020-05-27 08:53:56 mariabackup: Generating a list of tablespaces 2020-05-27 8:53:56 0 [Warning] InnoDB: Allocated tablespace ID 343 for portal_hdbank/users, old maximum was 0 [00] 2020-05-27 08:53:57 mariabackup: Incompatible TRUNCATE operation detected. Use --lock-ddl-per-table to lock all tables before backup. [00] 2020-05-27 08:53:57 Error: copying the log failed [00] FATAL ERROR: 2020-05-27 08:53:57 xtrabackup_copy_logfile() failed.

 
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.