Debian Codegraph @

mysql-test/suite/mariabackup/absolute_ibdata_paths.test

raw
1 # This test just backs up and restores empty database
2 # Innodb system tablespace is specified with absolute path in the .opt file
3 CREATE TABLE t(i INT) ENGINE INNODB;
4 INSERT INTO t VALUES(1);
5
6 let INNODB_PAGE_SIZE=`select @@innodb_page_size`;
7 let MYSQLD_DATADIR= `SELECT @@datadir`;
8 --source include/shutdown_mysqld.inc
9 perl;
10 my $file= "$ENV{MYSQLD_DATADIR}/ibdata_second";
11 open(FILE, "+<", $file) or die "Unable to open $file\n";
12 binmode FILE;
13 my $ps= $ENV{INNODB_PAGE_SIZE};
14 my $page;
15 my $pos = $ps * 0;
16 sysseek(FILE, $pos, 0) || die "Unable to seek $file\n";
17 die "Unable to read $file" unless sysread(FILE, $page, $ps) == $ps;
18 substr($page,26,8) = pack("NN", 1, 1);
19 sysseek(FILE, $pos, 0) || die "Unable to rewind $file\n";
20 syswrite(FILE, $page, $ps)==$ps || die "Unable to write $file\n";
21 close(FILE) || die "Unable to close $file\n";
22 EOF
23
24 --source include/start_mysqld.inc
25
26 echo # xtrabackup backup;
27
28 let $targetdir=$MYSQLTEST_VARDIR/tmp/backup;
29 let $_innodb_data_file_path=`select @@innodb_data_file_path`;
30 let $_innodb_data_home_dir=`select @@innodb_data_home_dir`;
31
32 --disable_result_log
33 exec $XTRABACKUP --defaults-file=$MYSQLTEST_VARDIR/my.cnf --backup --parallel=10 --target-dir=$targetdir;
34 --enable_result_log
35 exec $XTRABACKUP --prepare --target-dir=$targetdir;
36
37 --source include/shutdown_mysqld.inc
38 echo # remove datadir;
39 rmdir $MYSQLD_DATADIR;
40 #remove out-of-datadir ibdata1
41 remove_file $MYSQLTEST_VARDIR/tmp/absolute_path_ibdata1;
42 echo # xtrabackup copy back;
43 exec $XTRABACKUP --defaults-file=$MYSQLTEST_VARDIR/my.cnf --copy-back --datadir=$MYSQLD_DATADIR --target-dir=$targetdir "--innodb_data_file_path=$_innodb_data_file_path" --innodb_data_home_dir=$_innodb_data_home_dir;
44 echo # restart server;
45 --source include/start_mysqld.inc
46 --enable_result_log
47
48 SELECT * from t;
49 DROP TABLE t;
50 rmdir $targetdir;
51