--source include/have_innodb.inc
let LOGDIR= $MYSQLTEST_VARDIR/log;
let TMPDIR= $MYSQLTEST_VARDIR/tmp;
let BACKUP1= $TMPDIR/backup1;
let BACKUP2= $TMPDIR/backup2;

CREATE DATABASE db1;

CREATE TABLE db1.t1(id INT)ENGINE=MyISAM;
CREATE TABLE db1.t0(num int, msg text) ENGINE= Innodb;
CREATE TABLE db1.test1(num int) ENGINE=InnoDB;

INSERT INTO db1.t1 VALUES(1),(2);

INSERT INTO db1.t0 VALUES (1,'initial state');
INSERT INTO db1.test1 VALUES (1);

--echo
--echo == Initial, full backup ==

FLUSH TABLES;
--exec $MYSQLBACKUP  --port=$MASTER_MYPORT --protocol=tcp --user=root --backup-dir=$BACKUP1  backup > $LOGDIR/backup-full.log 2>&1

INSERT INTO db1.t1 VALUES(3),(4);
INSERT INTO db1.t0 VALUES (2,'before 1st incremental backup');

--echo
--echo == First incremental backup ==

FLUSH TABLES;
--exec $MYSQLBACKUP  --port=$MASTER_MYPORT  --protocol=tcp --user=root --incremental --start-lsn=$BACKUP_LSN1 --incremental-backup-dir=$BACKUP2 backup > $LOGDIR/backup-inc1.log 2>&1

--echo
--echo == Restoring data from full backup ==

--echo # Stopping server.
--source suite/meb/include/stop_mysqld.inc

 --exec $MYSQLBACKUP --defaults-group-suffix=.1 --incremental-backup-dir=$BACKUP1 --backup-dir=$BACKUP1 apply-log >$LOGDIR/restore-full.log 2>&1

--exec $MYSQLBACKUP --defaults-file=$MYSQLTEST_VARDIR/my.cnf --defaults-group-suffix=.1 --port=$MASTER_MYPORT --protocol=tcp --user=root --backup-dir=$BACKUP1  copy-back >>$LOGDIR/restore-full.log 2>&1

--echo # Re-starting server.
--source suite/meb/include/restart_mysqld.inc

SELECT * FROM db1.t0 ORDER BY num;
SELECT * FROM db1.t1;

--echo # Good - data restored correctly

--echo
--echo == Restoring data from first incremental backup ==

--echo # Stopping server.
--source suite/meb/include/stop_mysqld.inc

--exec $MYSQLBACKUP --defaults-group-suffix=.1 --incremental-backup-dir=$BACKUP2 --backup-dir=$BACKUP1 apply-incremental-backup >$LOGDIR/restore-inc1.log 2>&1

--exec $MYSQLBACKUP --defaults-file=$MYSQLTEST_VARDIR/my.cnf --defaults-group-suffix=.1 --port=$MASTER_MYPORT --protocol=tcp --user=root --backup-dir=$BACKUP1  copy-back >>$LOGDIR/restore-inc1.log 2>&1

--echo # Re-starting server.
--source suite/meb/include/restart_mysqld.inc

SELECT * FROM db1.t0 ORDER BY num;
SELECT * FROM db1.t1;

--echo # Good - data restored correctly

DROP DATABASE db1;
DROP DATABASE mysql.backup_history;
DROP DATABASE mysql.backup_progress;