summaryrefslogtreecommitdiff
path: root/mysql-test/suite/mariabackup/include/show_xtrabackup_slave_info.inc
blob: 4a83c9c394e7f83f2e4d99eb4b115e5b0057d033 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
--disable_query_log
--file_exists $targetdir/xtrabackup_slave_info
CREATE TEMPORARY TABLE tmp_slave_info(lineno SERIAL, line TEXT);
--replace_result $targetdir TARGETDIR
--eval LOAD DATA LOCAL INFILE '$targetdir/xtrabackup_slave_info' INTO TABLE tmp_slave_info (line);
SELECT
  lineno,
  regexp_replace(
  regexp_replace(line, '(?<=MASTER_LOG_POS=)[0-9]+', '<NUM>'),
                       '[0-9]+-[0-9]+-[0-9]+', '<NUM-NUM-NUM>')
  AS line
FROM tmp_slave_info ORDER BY lineno;
DROP TEMPORARY TABLE tmp_slave_info;
--enable_query_log