1DROP DATABASE IF EXISTS hotcopy_test; 2CREATE DATABASE hotcopy_test; 3USE hotcopy_test; 4CREATE TABLE t1 (c1 int, c2 varchar(20)) ENGINE=MyISAM; 5CREATE TABLE t2 (c1 int, c2 varchar(20)) ENGINE=MyISAM; 6CREATE TABLE t3 (c1 int, c2 varchar(20)) ENGINE=MyISAM; 7INSERT INTO t1 VALUES (1,'aaaaaaaaaaaaaaaaaaaa'),(2, 'bbbbbbbbbbbbbbbbbbbbbbb'); 8Warnings: 9Warning 1406 Data too long for column 'c2' at row 2 10INSERT INTO t2 VALUES (1,'aaaaaaaaaaaaaaaaaaaa'),(2, 'bbbbbbbbbbbbbbbbbbbbbbb'); 11Warnings: 12Warning 1406 Data too long for column 'c2' at row 2 13INSERT INTO t3 VALUES (1,'aaaaaaaaaaaaaaaaaaaa'),(2, 'bbbbbbbbbbbbbbbbbbbbbbb'); 14Warnings: 15Warning 1406 Data too long for column 'c2' at row 2 16db.opt 17t1.MYD 18t1.MYI 19t1.frm 20t2.MYD 21t2.MYI 22t2.frm 23t3.MYD 24t3.MYI 25t3.frm 26db.opt 27t1.MYD 28t1.MYI 29t1.frm 30t2.MYD 31t2.MYI 32t2.frm 33t3.MYD 34t3.MYI 35t3.frm 36USE hotcopy_save; 37SELECT * FROM t1; 38c1 c2 391 aaaaaaaaaaaaaaaaaaaa 402 bbbbbbbbbbbbbbbbbbbb 41SELECT * FROM t2; 42c1 c2 431 aaaaaaaaaaaaaaaaaaaa 442 bbbbbbbbbbbbbbbbbbbb 45SELECT * FROM t3; 46c1 c2 471 aaaaaaaaaaaaaaaaaaaa 482 bbbbbbbbbbbbbbbbbbbb 49USE hotcopy_test; 50DELETE FROM t1; 51SELECT * FROM t1; 52c1 c2 53USE hotcopy_save; 54SELECT * FROM t1; 55c1 c2 561 aaaaaaaaaaaaaaaaaaaa 572 bbbbbbbbbbbbbbbbbbbb 58SELECT * FROM t2; 59c1 c2 601 aaaaaaaaaaaaaaaaaaaa 612 bbbbbbbbbbbbbbbbbbbb 62SELECT * FROM t3; 63c1 c2 641 aaaaaaaaaaaaaaaaaaaa 652 bbbbbbbbbbbbbbbbbbbb 66USE hotcopy_test; 67DROP TABLE t2; 68db.opt 69t1.MYD 70t1.MYI 71t1.frm 72t3.MYD 73t3.MYI 74t3.frm 75FLUSH TABLES; 76SELECT * FROM t1; 77c1 c2 781 aaaaaaaaaaaaaaaaaaaa 792 bbbbbbbbbbbbbbbbbbbb 80SELECT * FROM t2; 81c1 c2 821 aaaaaaaaaaaaaaaaaaaa 832 bbbbbbbbbbbbbbbbbbbb 84SELECT * FROM t3; 85c1 c2 861 aaaaaaaaaaaaaaaaaaaa 872 bbbbbbbbbbbbbbbbbbbb 88USE hotcopy_test; 89db.opt 90t1.MYD 91t1.MYI 92t1.frm 93t2.MYD 94t2.MYI 95t2.frm 96t3.MYD 97t3.MYI 98t3.frm 99DROP DATABASE hotcopy_save; 100db.opt 101t1.MYD 102t1.MYI 103t1.frm 104t2.MYD 105t2.MYI 106t2.frm 107t3.MYD 108t3.MYI 109t3.frm 110DROP DATABASE hotcopy_save; 111db.opt 112t1.MYD 113t1.MYI 114t1.frm 115t2.MYD 116t2.MYI 117t2.frm 118t3.MYD 119t3.MYI 120t3.frm 121db.opt 122t1.MYD 123t1.MYI 124t1.frm 125t2.MYD 126t2.MYI 127t2.frm 128t3.MYD 129t3.MYI 130t3.frm 131db.opt 132t1.MYD 133t1.MYI 134t1.frm 135t2.MYD 136t2.MYI 137t2.frm 138t3.MYD 139t3.MYI 140t3.frm 141db.opt 142t1.MYD 143t1.MYI 144t1.frm 145t2.MYD 146t2.MYI 147t2.frm 148t3.MYD 149t3.MYI 150t3.frm 151db.opt 152t1.MYD 153t1.MYI 154t1.frm 155t2.MYD 156t2.MYI 157t2.frm 158t3.MYD 159t3.MYI 160t3.frm 161DROP DATABASE hotcopy_test_cpy; 162DROP DATABASE hotcopy_test; 163DROP DATABASE hotcopy_save; 164DROP DATABASE hotcopy_save_old; 165