Debian Codegraph @

mysql-test/suite/innodb/include/import.inc

raw
1 # Export Table and Import from saved files .cfg and .ibd
2 # Caller should create t1 table definition and populate table
3
4 let $MYSQLD_DATADIR = `SELECT @@datadir`;
5
6 if(!$source_db) {
7 let $source_db = test;
8 }
9
10 if(!$dest_db) {
11 let $dest_db = test;
12 }
13
14 eval FLUSH TABLES $source_db.t1 FOR EXPORT;
15
16 --copy_file $MYSQLD_DATADIR/$source_db/t1.cfg $MYSQLD_DATADIR/t1.cfg_back
17 --copy_file $MYSQLD_DATADIR/$source_db/t1.ibd $MYSQLD_DATADIR/t1.ibd_back
18
19 UNLOCK TABLES;
20
21 if($source_db != $dest_db) {
22 eval USE $dest_db;
23 let $create1 = query_get_value(SHOW CREATE TABLE $source_db.t1, Create Table, 1);
24 eval $create1;
25 }
26
27 eval ALTER TABLE $dest_db.t1 DISCARD TABLESPACE;
28
29 --move_file $MYSQLD_DATADIR/t1.cfg_back $MYSQLD_DATADIR/$dest_db/t1.cfg
30 --move_file $MYSQLD_DATADIR/t1.ibd_back $MYSQLD_DATADIR/$dest_db/t1.ibd
31
32 eval ALTER TABLE $dest_db.t1 IMPORT TABLESPACE;
33
34 eval CHECK TABLE $dest_db.t1;
35 eval SHOW CREATE TABLE $dest_db.t1;
36 eval SELECT * FROM $dest_db.t1;
37
38 if($source_db != $dest_db) {
39 eval DROP TABLE $dest_db.t1;
40 }