published under license CC4-BY
posted in category Systems Software / MySQL & MariaDB
posted at 05. Oct '25
Howto Backup MariaDB With mariadb-backup
$ mariadb-backup --backup --target-dir dbackups --user root
[00] 2024-10-07 02:46:15 Connecting to MariaDB server host: localhost, user: root, password: not set, port: 3306, socket: /var/run/mysqld/mysqld.sock
[00] 2024-10-07 02:46:15 Using server version 10.11.6-MariaDB-0+deb12u1-log
mariadb-backup based on MariaDB server 10.11.6-MariaDB debian-linux-gnu (x86_64)
[00] 2024-10-07 02:46:15 uses posix_fadvise().
[00] 2024-10-07 02:46:15 cd to /var/lib/mysql/
[00] 2024-10-07 02:46:15 open files limit requested 0, set to 1024
[00] 2024-10-07 02:46:15 mariabackup: using the following InnoDB configuration:
[00] 2024-10-07 02:46:15 innodb_data_home_dir =
[00] 2024-10-07 02:46:15 innodb_data_file_path = ibdata1:12M:autoextend
[00] 2024-10-07 02:46:15 innodb_log_group_home_dir = ./
[00] 2024-10-07 02:46:15 InnoDB: Using liburing
2024-10-07 2:46:15 0 [Note] InnoDB: Number of transaction pools: 1
2024-10-07 2:46:15 0 [Note] InnoDB: Buffered log writes (block size=512 bytes)
[00] 2024-10-07 02:46:15 mariabackup: Generating a list of tablespaces
...
[00] 2024-10-07 02:46:16 Writing xtrabackup_binlog_info
[00] 2024-10-07 02:46:16 ...done
[00] 2024-10-07 02:46:16 Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS...
[00] 2024-10-07 02:46:16 mariabackup: The latest check point (for incremental): '45646'
mariabackup: Stopping log copying thread.
[00] 2024-10-07 02:46:17 Executing BACKUP STAGE END
[00] 2024-10-07 02:46:17 All tables unlocked
[00] 2024-10-07 02:46:17 Backup created in directory '/root/dbackups/'
[00] 2024-10-07 02:46:17 MySQL binlog position: filename 'mariadb-bin.002485', position '28486', GTID of the last change '0-1-63359603'
[00] 2024-10-07 02:46:17 Writing backup-my.cnf
[00] 2024-10-07 02:46:17 ...done
[00] 2024-10-07 02:46:17 Writing xtrabackup_info
[00] 2024-10-07 02:46:17 ...done
[00] 2024-10-07 02:46:17 Redo log (from LSN 45646 to 522521) was copied.
[00] 2024-10-07 02:46:17 completed OK!
And the backup will be in /root/dbackups/
.
Add Comment