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