| 1 |
--disable_query_log |
| 2 |
--file_exists $targetdir/mariadb_backup_slave_info |
| 3 |
CREATE TEMPORARY TABLE tmp_slave_info(lineno SERIAL, line TEXT); |
| 4 |
--replace_result $targetdir TARGETDIR |
| 5 |
--eval LOAD DATA LOCAL INFILE '$targetdir/mariadb_backup_slave_info' INTO TABLE tmp_slave_info (line); |
| 6 |
SELECT |
| 7 |
lineno, |
| 8 |
regexp_replace( |
| 9 |
regexp_replace(line, '(?<=MASTER_LOG_POS=)[0-9]+', '<NUM>'), |
| 10 |
'[0-9]+-[0-9]+-[0-9]+', '<NUM-NUM-NUM>') |
| 11 |
AS line |
| 12 |
FROM tmp_slave_info ORDER BY lineno; |
| 13 |
DROP TEMPORARY TABLE tmp_slave_info; |
| 14 |
--enable_query_log |