#
# mysqlbackup needs to connect to the server. Not supported in embedded.
--source include/not_embedded.inc
#
# This test case needs InnoDB.
--source include/have_innodb.inc
#
# Check for existence of mysqlbackup and set up environment for it.
--source suite/backup/include/have_backup.inc

# Mysqlbackup tool is introduced only in MEB 3.6 version
--source suite/backup/include/have_meb_3_6.inc

#
# Set path names.
#
--let $BACKUP_LOG = $MYSQLTEST_VARDIR/tmp/backup.log
--let $REPLAY_LOG = $MYSQLTEST_VARDIR/tmp/replay.log
--let $CPBACK_LOG = $MYSQLTEST_VARDIR/tmp/cpback.log
--let BACKUP_TARGET_DIR = $MYSQLTEST_VARDIR/tmp/meb_bup_dir
--let $MYSQLD_DATADIR = `SELECT @@datadir`

--echo #
--echo # Precautionary clean up.
--echo #
--exec perl suite/meb/include/rmtree.pl $BACKUP_TARGET_DIR


CREATE DATABASE dbb;
CREATE TABLE dbb.td1(id INT)ENGINE=INNODB;
INSERT INTO dbb.td1 VALUES (1),(2),(3),(4),(5);

CREATE TABLE dbb.te4(id INT)ENGINE=MEMORY;
INSERT INTO dbb.te4 VALUES(1),(100);

--exec $MYSQLBACKUP --defaults-file=$MYSQLTEST_VARDIR/my.cnf --port=$MASTER_MYPORT  --protocol=tcp --user=root --backup-dir=$BACKUP_TARGET_DIR   backup >$BACKUP_LOG 2>&1

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

#
# Prepare for Restore.
# Apply InnoDB log file.
#
--echo #
--echo # Run mysqlbackup for apply log.
--exec $MYSQLBACKUP --defaults-group-suffix=.1 --backup-dir=$BACKUP_TARGET_DIR  apply-log > $REPLAY_LOG 2>&1
--echo ...
# If not success, mysqltest would exit after exec.
--echo # Success
--echo

#
--echo #
--echo # Run mysqlbackup for copy back.
--exec $MYSQLBACKUP --defaults-file=$MYSQLTEST_VARDIR/my.cnf --defaults-group-suffix=.1  --port=$MASTER_MYPORT --protocol=tcp --user=root --backup-dir=$BACKUP_TARGET_DIR  copy-back > $CPBACK_LOG 2>&1
--echo ...
# If not success, mysqltest would exit after exec.
--echo # Success
--echo

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

#
# Show the restored data.
#
SELECT * FROM dbb.td1;
SELECT * FROM dbb.te4;

DROP DATABASE dbb;