mysql-test/suite/mariabackup/xb_history.test


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27

#--source include/innodb_page_size.inc

--disable_warnings
DROP TABLE IF EXISTS mysql.mariadb_backup_history;
--enable_warnings

let $targetdir=$MYSQLTEST_VARDIR/tmp/backup;
--disable_result_log
exec $XTRABACKUP --defaults-file=$MYSQLTEST_VARDIR/my.cnf --history=foo --backup --target-dir=$targetdir;
--enable_result_log
rmdir $targetdir;

SHOW CREATE TABLE mysql.mariadb_backup_history;
SELECT COUNT(*) FROM mysql.mariadb_backup_history;
SELECT name FROM mysql.mariadb_backup_history;

let $targetdir=$MYSQLTEST_VARDIR/tmp/backup;
--disable_result_log
exec $XTRABACKUP --defaults-file=$MYSQLTEST_VARDIR/my.cnf --history --backup --target-dir=$targetdir;
--enable_result_log
rmdir $targetdir;

SELECT COUNT(*) FROM mysql.mariadb_backup_history;
--sorted_result
SELECT name FROM mysql.mariadb_backup_history;

DROP TABLE mysql.mariadb_backup_history;