1
SET DEBUG_SYNC= 'RESET';
2
DROP DATABASE IF EXISTS mysqltest;
3
CREATE DATABASE mysqltest;
5
CREATE TABLE t1 (c1 LONGTEXT) ENGINE=MyISAM;
7
connection backup: Start backup
8
SET DEBUG_SYNC= 'before_backup_data_prepare SIGNAL bup_sync
10
BACKUP DATABASE mysqltest TO 'test.ba';
12
connection default: Wait for BACKUP to reach its sync point
13
SET DEBUG_SYNC= 'now WAIT_FOR bup_sync';
15
INSERT INTO t1 VALUES ("text");
16
UPDATE t1 SET c1=concat(c1,c1);
17
UPDATE t1 SET c1=concat(c1,c1);
18
UPDATE t1 SET c1=concat(c1,c1);
19
UPDATE t1 SET c1=concat(c1,c1);
20
UPDATE t1 SET c1=concat(c1,c1);
21
UPDATE t1 SET c1=concat(c1,c1);
22
UPDATE t1 SET c1=concat(c1,c1);
23
UPDATE t1 SET c1=concat(c1,c1);
24
UPDATE t1 SET c1=concat(c1,c1);
25
UPDATE t1 SET c1=concat(c1,c1);
26
UPDATE t1 SET c1=concat(c1,c1);
27
UPDATE t1 SET c1=concat(c1,c1);
28
UPDATE t1 SET c1=concat(c1,c1);
29
UPDATE t1 SET c1=concat(c1,c1);
30
UPDATE t1 SET c1=concat(c1,c1);
31
UPDATE t1 SET c1=concat(c1,c1);
32
SELECT LENGTH(c1) FROM t1;
37
mysqltest.t1 1728069308
38
Signal BACKUP to finish
39
SET DEBUG_SYNC= 'now SIGNAL bup_finish';
41
connection backup: Fetch result
44
REPAIR TABLE t1 QUICK;
45
Table Op Msg_type Msg_text
46
mysqltest.t1 repair status OK
47
DROP DATABASE mysqltest;
48
RESTORE FROM 'test.ba';
51
SELECT LENGTH(c1) FROM t1;
56
mysqltest.t1 1728069308
58
connection default: cleanup
59
SET DEBUG_SYNC= 'RESET';
62
# Bug#38045 - Backup, MyISAM and file system encoding
64
CREATE TABLE `���ߣ�` (id SERIAL) ENGINE=MyISAM;
65
BACKUP DATABASE mysqltest TO 'test.ba';
72
DROP DATABASE mysqltest;
73
SET DEBUG_SYNC= 'RESET';