← All stickers JamES

Copying InnoDB tables between servers

10 years ago

set global innodb_import_table_from_xtrabackup=1

10 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=

10 years ago

alter table tbl discard tablespace;

10 years ago

alter table tbl import tablespace;

Ctrl + Enter

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

Tweet

Recommendations