mysql数据库备份工具

1，CMS 帝国备份王(Empir ebak)  http://ebak.phome.net/ebak/

2，超级牛B的mysql备份工具 XtraBackup

数据表分区 删除操作

 

DELETE FROM tp_goods_collect PARTITION (p0) WHERE delete_time >0 limit 5000;
DELETE FROM tp_goods_collect PARTITION (p1) WHERE delete_time >0 limit 5000;
DELETE FROM tp_goods_collect PARTITION (p2) WHERE delete_time >0 limit 5000;
DELETE FROM tp_goods_collect PARTITION (p3) WHERE delete_time >0 limit 5000;
DELETE FROM tp_goods_collect PARTITION (p4) WHERE delete_time >0 limit 5000;
DELETE FROM tp_goods_collect PARTITION (p5) WHERE delete_time >0 limit 5000;
DELETE FROM tp_goods_collect PARTITION (p6) WHERE delete_time >0 limit 5000;
DELETE FROM tp_goods_collect PARTITION (p7) WHERE delete_time >0 limit 5000;
DELETE FROM tp_goods_collect PARTITION (p8) WHERE delete_time >0 limit 5000;

。。。。  

到PARTITION (p99)