1#--source include/innodb_page_size.inc
2--source include/have_file_key_management.inc
3
4CREATE TABLE film_text (
5film_id SMALLINT NOT NULL,
6title VARCHAR(255) NOT NULL,
7description TEXT,
8PRIMARY KEY (film_id),
9FULLTEXT KEY idx_title_description (title,description),
10FULLTEXT KEY (description),
11FULLTEXT KEY (title)
12)ENGINE=InnoDB DEFAULT CHARSET=utf8 ENCRYPTED=YES;
13
14let $targetdir=$MYSQLTEST_VARDIR/tmp/backup;
15
16--disable_result_log
17
18exec $INNOBACKUPEX --defaults-file=$MYSQLTEST_VARDIR/my.cnf --no-timestamp $targetdir;
19exec $INNOBACKUPEX --apply-log $targetdir;
20--source include/restart_and_restore.inc
21
22--enable_result_log
23
24drop table film_text;
25