← All stickers JamES

Copying InnoDB tables between servers

11 years ago

set global innodb_import_table_from_xtrabackup=1

11 years ago

xtrabackup --defaults-file=/etc/my.cnf --backup --tables=tpcc.* --target-dir=

xtrabackup --defaults-file=/etc/my.cnf --prepare --export --use-memory=8G --target-dir=

11 years ago

alter table tbl discard tablespace;

11 years ago

alter table tbl import tablespace;

Ctrl + Enter

JamES 12 years ago: Group: webdev; Tags: mysql, xtrabackup; 1 0 0 0; Favorite

Tweet

Recommendations