2

I have a MySQL 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 an entire MySQL partition from one machine to another?

Continuation
  • 3,080
  • 5
  • 30
  • 38

1 Answers1

1

I have plenty of MySQL experience, but I don't have any experience with MySQL partitions, however, I was able to dig up the following URL. Sorry I couldn't be of more help!

http://forums.mysql.com/read.php?106,199428,199428

drewrockshard
  • 1,763
  • 4
  • 20
  • 27