--source include/not_embedded.inc
# Check for existence of innobackup and set up environment for it.
#--source suite/meb/include/have_meb.inc
# Innobackup tests will not be run in windows
--source include/not_windows.inc

#
# Get miscellaneous 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 $MYSQLD_DATADIR = `SELECT @@datadir`;
LET $BACKUP_TARGET_DIR = $MYSQLTEST_VARDIR/tmp/innobackup;

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

--echo --------------------------------------------------------------
--echo # Start creating databases and tables
# Assign the following variables to use extreme_data.inc file for creating
# tables

# Enable InnoDB storage engine using have_innodb.inc
--source include/have_innodb.inc

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

CREATE TABLE dbb.td2(a CHAR(10))ENGINE=MyISAM;
INSERT INTO dbb.td2 VALUES('a'),('b'),('c'),('d');

CREATE TABLE dbb.td3(id INT, a CHAR(5))ENGINE=INNODB;

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

CREATE TABLE dbb.te2(a CHAR(5))ENGINE=INNODB;
CREATE TABLE dbb.tf1(a VARCHAR(10), id INT)ENGINE=INNODB;
INSERT INTO dbb.tf1 VALUES('a',10),('b',20);

--echo # Done creating databases and tables.
--echo ----------------------------------------------------------------
--echo # Start the tests ....

CREATE USER 'tom'@'localhost' IDENTIFIED BY 'abc';
GRANT ALL ON *.* TO 'tom'@'localhost';
GRANT GRANT OPTION ON *.* TO 'tom'@'localhost';

--echo TEST 3c:Perform backup with --user without giving --password option
--echo # Running sample.pl .....
--echo # ....

--exec perl include/sample.pl $MASTER_MYPORT > $BACKUP_LOG

--exec perl suite/meb/include/rmtree.pl $BACKUP_TARGET_DIR
DROP DATABASE dbb;
--source suite/meb/include/cleanup_meb.inc