| 1 |
call mtr.add_suppression("InnoDB: New log files created"); |
| 2 |
SET GLOBAL innodb_file_per_table=0; |
| 3 |
Warnings: |
| 4 |
Warning 1287 '@@innodb_file_per_table' is deprecated and will be removed in a future release |
| 5 |
CREATE TABLE t(a varchar(40) PRIMARY KEY, b varchar(40), c varchar(40), d varchar(40), index(b,c,d)) ENGINE INNODB; |
| 6 |
# Create full backup , modify table, then create incremental/differential backup |
| 7 |
SET debug_dbug='+d,skip_page_checksum',foreign_key_checks=0,unique_checks=0; |
| 8 |
BEGIN; |
| 9 |
INSERT INTO t select uuid(), uuid(), uuid(), uuid() from seq_1_to_100000; |
| 10 |
COMMIT; |
| 11 |
SELECT count(*) FROM t; |
| 12 |
count(*) |
| 13 |
100000 |
| 14 |
# Prepare full backup, apply incremental one |
| 15 |
# Restore and check results |
| 16 |
# shutdown server |
| 17 |
# remove datadir |
| 18 |
# xtrabackup move back |
| 19 |
# restart server |
| 20 |
# restart |
| 21 |
SELECT count(*) FROM t; |
| 22 |
count(*) |
| 23 |
100000 |
| 24 |
DROP TABLE t; |