mirror of
https://github.com/MariaDB/server.git
synced 2025-02-12 00:15:35 +01:00
b314f7b642
Renaming the default MariaDB backup directory from xtrabackup_backupfiles to mariadb_backup_files. Renaming files: - xtrabackup_binlog_info to mariadb_backup_binlog_info - xtrabackup_checkpoints to mariadb_backup_checkpoints - xtrabackup_galera_info to mariadb_backup_galera_info - xtrabackup_info to mariadb_backup_info - xtrabackup_slave_info to mariadb_backup_slave_info
14 lines
542 B
SQL
14 lines
542 B
SQL
--disable_query_log
|
|
--file_exists $targetdir/mariadb_backup_slave_info
|
|
CREATE TEMPORARY TABLE tmp_slave_info(lineno SERIAL, line TEXT);
|
|
--replace_result $targetdir TARGETDIR
|
|
--eval LOAD DATA LOCAL INFILE '$targetdir/mariadb_backup_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
|