mirror of
https://github.com/MariaDB/server.git
synced 2025-08-08 11:22:35 +03:00
15 lines
284 B
Plaintext
15 lines
284 B
Plaintext
CREATE TABLE t1(c1 INT, b VARCHAR(2400), index(b(100),c1))
|
|
ENGINE=INNODB ROW_FORMAT=compressed ENCRYPTED=YES;
|
|
BEGIN;
|
|
COMMIT;
|
|
# xtrabackup backup
|
|
drop table t1;
|
|
# shutdown server
|
|
# remove datadir
|
|
# xtrabackup move back
|
|
# restart
|
|
select sum(c1) from t1;
|
|
sum(c1)
|
|
12497500
|
|
DROP TABLE t1;
|