summaryrefslogtreecommitdiff
path: root/mysql-test/include/ndb_backup.inc
blob: ea56d79cbba9bcda3ad013fc4162b73f55a5206d (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
######################################################
# By JBM 2006-02-16 So that the code is not repeated #
# in test cases and can be reused.                   #
######################################################

# Bug#41307: Tests using include/ndb_backup.inc won't work on Windows due to
#            'grep' call
# This test is disabled on Windows via the next line until the above bug is
# resolved
--source include/not_windows.inc

--exec $NDB_MGM --no-defaults --ndb-connectstring="$NDB_CONNECTSTRING" -e "start backup" >> $NDB_TOOLS_OUTPUT

# there is no neat way to find the backupid, this is a hack to find it...
let $dump_file= $MYSQLTEST_VARDIR/tmp/tmp.dat;
--exec $NDB_TOOLS_DIR/ndb_select_all --ndb-connectstring="$NDB_CONNECTSTRING" -d sys --delimiter=',' SYSTAB_0 | grep 520093696 > $dump_file

CREATE TEMPORARY TABLE test.backup_info (id INT, backup_id INT) ENGINE = HEAP;

--replace_result $dump_file DUMP_FILE
eval LOAD DATA INFILE '$dump_file' INTO TABLE test.backup_info FIELDS TERMINATED BY ',';

# Load backup id into environment variable
let the_backup_id=`SELECT  backup_id from test.backup_info`;
DROP TABLE test.backup_info;

remove_file $dump_file;