--source include/master-slave.inc
--echo
--echo # Connecting to master...
--echo
connection master;

--echo # Get master's datadir.
let $MYSQLD_M_DATADIR= `select @@datadir`;

CREATE DATABASE db1;
CREATE TABLE db1.t12(details CHAR(30));
CREATE EVENT db1.e1 ON SCHEDULE AT CURRENT_TIMESTAMP
  ON COMPLETION PRESERVE DISABLE
  DO INSERT INTO db1.t12 VALUES('event e1 fired');

--replace_column 1 #
BACKUP DATABASE db1 TO 'db1m.bak';

--echo # Connecting to slave...
sync_slave_with_master;
connection slave;

--echo # Get slave's datadir.
let $MYSQLD_S_DATADIR= `select @@datadir`;

--replace_column 1 #
BACKUP DATABASE db1 TO 'db1s.bak';

--copy_file $MYSQLD_S_DATADIR/db1s.bak $MYSQLD_M_DATADIR/db1s.bak
file_exists $MYSQLD_M_DATADIR/db1s.bak;

connection master;
--replace_column 1 #
RESTORE FROM 'db12s.bak' OVERWRITE;

DROP DATABASE db1;
--remove_file $MYSQLD_M_DATADIR/db12s.bak
--remove_file $MYSQLD_M_DATADIR/db12m.bak

connection slave;
STOP SLAVE;
--remove_file $MYSQLD_S_DATADIR/db12s.bak