--source include/master-slave.inc
--source include/not_embedded.inc

connection master;

--disable_warnings
drop schema if exists mydb1;
create schema mydb1;
--enable_warnings

create table mydb1.t1( id int not null) engine = myisam;

insert into mydb1.t1 values (1), (2), (3);

sync_slave_with_master;

connection master;

--replace_column 1 #
backup schema mydb1 to 'mydb1.bkp';

drop schema mydb1;

--replace_column 1 #
restore from 'mydb1.bkp';

--echo # records on master
select count(*) from mydb1.t1;

--echo # records on slave
connection slave;

STOP SLAVE;
--source include/wait_for_slave_to_stop.inc

--echo Show the slave stopped with an error.
LET $last_error = query_get_value("SHOW SLAVE STATUS", Last_SQL_Error, 1);
disable_query_log;
eval SELECT "$last_error" AS Last_SQL_Error;
enable_query_log;

SET global sql_slave_skip_counter=1;

START SLAVE;
--source include/wait_for_slave_to_start.inc

show databases;

connection master;
drop schema mydb1;

--remove_file $MYSQLTEST_VARDIR/master-data/mydb1.bkp