MySQL Forums
Forum List  »  Partitioning

How to move InnoDB partitions from one machine to another?
Posted by: John Smith
Date: August 26, 2010 03:16AM

I have an InnoDB table:

CREATE TABLE tweets (
tweet_id INT NOT NULL AUTO_INCREMENT,
author_id INT NOT NULL,
text CHAR(140) NOT NULL,
PRIMARY KEY (tweet_id)
)
ENGINE=InnoDB
PARTITION BY HASH(tweet_id)
PARTITIONS 12;

How do I move selected partitions from this table to a different machine?

For example, I'd want to move partitions 1, 3, 5, 7, 9, 11 of the above 12 partitions to a different machine. And I'd need to make sure the auto-increment PK "tweet_id" remains unchanged during the migration.

Is there a way to move selected InnoDB partitions from one machine to another?

Options: ReplyQuote


Subject
Views
Written By
Posted
How to move InnoDB partitions from one machine to another?
2963
August 26, 2010 03:16AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.