| 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 |
} |