mysql 水平分区备份问题？

gxlxld

我一个表，进行了分区如下
PARTITION BY RANGE COLUMNS(id)
(
PARTITION p1 VALUES LESS THAN(300000),
PARTITION p2 VALUES LESS THAN(600000),
PARTITION p3 VALUES LESS THAN(900000),
PARTITION p4 VALUES LESS THAN(1200000),
PARTITION p5 VALUES LESS THAN(1500000),
PARTITION p6 VALUES LESS THAN(1800000),
PARTITION p7 VALUES LESS THAN(2100000),
PARTITION p8 VALUES LESS THAN(2400000),
PARTITION p9 VALUES LESS THAN(2700000),
PARTITION p10 VALUES LESS THAN(3000000),
PARTITION pmax VALUES LESS THAN(MAXVALUE)
）;
问题一：备份的时候，只备份p5,p9如何操作？
问题二：只想删除分区p1,p2,p3，如何操作？

wutuobangduan

删除分区使用alter table tablename drop partition p1,p2,p3;

chinafenghao

@gxlxld
通过逻辑备份,select * from table where xxx  into outfile 'xx';