| 1 |
--disable_query_log |
| 2 |
--file_exists $XTRABACKUP_OUT |
| 3 |
CREATE TEMPORARY TABLE tmp_slave_info_out(lineno SERIAL, line TEXT); |
| 4 |
--replace_result $targetdir TARGETDIR |
| 5 |
--eval LOAD DATA LOCAL INFILE '$XTRABACKUP_OUT' INTO TABLE tmp_slave_info_out (line); |
| 6 |
SELECT |
| 7 |
replace( |
| 8 |
regexp_replace( |
| 9 |
regexp_replace(line, |
| 10 |
'[0-9][0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9] [0-9][0-9]:[0-9][0-9]:[0-9][0-9]', |
| 11 |
'YYYY-MM-DD hh:mm:ss'), |
| 12 |
'[0-9]+-[0-9]+-[0-9]+', '<NUM-NUM-NUM>'), |
| 13 |
'\r','' /* Remove CR on Windows */) |
| 14 |
AS line |
| 15 |
FROM tmp_slave_info_out |
| 16 |
WHERE line LIKE '%MySQL slave binlog position%' |
| 17 |
OR line LIKE '%Failed to get master binlog coordinates%' |
| 18 |
ORDER BY lineno; |
| 19 |
DROP TEMPORARY TABLE tmp_slave_info_out; |
| 20 |
--enable_query_log |