mirror of
https://github.com/MariaDB/server.git
synced 2025-08-30 06:11:35 +02:00
37 lines
778 B
Text
37 lines
778 B
Text
CREATE TABLE t(i INT) ENGINE INNODB;
|
|
INSERT INTO t VALUES(1);
|
|
# xtrabackup full backup to stream
|
|
INSERT INTO t VALUES(2), (3), (4);
|
|
# xtrabackup incremental backup to stream
|
|
# checking recording of history
|
|
SELECT tool_name, name, partial, incremental, format, compressed
|
|
FROM mysql.mariadb_backup_history
|
|
ORDER BY innodb_from_lsn;
|
|
tool_name mariadb-backup
|
|
name fullback
|
|
partial Y
|
|
incremental N
|
|
format mbstream
|
|
compressed N
|
|
tool_name mariadb-backup
|
|
name incr_1
|
|
partial N
|
|
incremental Y
|
|
format mbstream
|
|
compressed N
|
|
# xbstream extract
|
|
# xtrabackup prepare
|
|
# xbstream extract for incremental backup
|
|
# xtrabackup incremental prepare
|
|
# shutdown server
|
|
# remove datadir
|
|
# xtrabackup move back
|
|
# restart
|
|
SELECT * FROM t;
|
|
i
|
|
1
|
|
2
|
|
3
|
|
4
|
|
DROP TABLE t;
|
|
DROP TABLE mysql.mariadb_backup_history;
|