1
--source include/not_embedded.inc
3
# Test that it is possible to restore backups of tables with more than
4
# a single block of data.
7
DROP DATABASE IF EXISTS mysqltest;
10
--echo Creating database and tables ...
11
CREATE DATABASE mysqltest;
14
CREATE TABLE t1 (a LONGTEXT) ENGINE=MYISAM;
16
--echo Inserting data ...
18
INSERT INTO t1 VALUES ("text");
22
UPDATE t1 SET a=CONCAT(a,a);
25
SELECT LENGTH(a) FROM t1;
27
--echo Performing backup ...
29
BACKUP DATABASE mysqltest TO 'test.ba';
31
DROP DATABASE mysqltest;
34
--echo Performing restore ...
36
RESTORE FROM 'test.ba';
38
--echo Checking contents of restore ...
39
SELECT LENGTH(a) FROM t1;
43
DROP DATABASE mysqltest;
44
--remove_file $MYSQLTEST_VARDIR/master-data/test.ba