Hey there! JamES is using Stickr.

Stickr is a free service that helps you comment and share anything on the Web, follow others comments and leave notes for yourself and your friends - on any website you want!
Join Stickr today to start following JamES's stickers and comment websites on your own.

Get started

Copying InnoDB tables between servers

JamES

11 years ago

set global innodb_import_table_from_xtrabackup=1

JamES

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=

JamES

11 years ago

alter table tbl discard tablespace;

JamES

11 years ago

alter table tbl import tablespace;

Add comments

Ctrl + Enter

Recommendations

Sticker Actions

  • left comment to sticker 15th Jun
  • left comment to sticker 15th Jun
  • left comment to sticker 15th Jun
Загрузка...