1
SET GLOBAL debug="d,backup:d,backup_data";
2
DROP DATABASE IF EXISTS db1;
4
CREATE TABLE db1.t1(a int) ENGINE=INNODB;
5
CREATE VIEW db1.v1 AS SELECT * FROM db1.t1;
6
CREATE VIEW db1.v2 AS SELECT * FROM db1.v1;
7
INSERT INTO db1.t1 VALUES (1),(2),(3),(5),(7),(11);
8
BACKUP DATABASE db1 TO 'test.bak';
11
RESTORE FROM 'test.bak';