+----------+
1 row in set (0.23 sec)
##导出备份
mysql> select * into outfile '/tmp/baby_account_change_log_p1.sql' from baby_account_change_log where updated_time >'2016-12-01 00:00:00' and updated_time <'2017-01-01 00:00:00' limit 100000000000;
Query OK, 66252 rows affected (2.71 sec)
##确认要处理分区
mysql> explain partitions select count(*) from baby_account_change_log where updated_time >'2016-12-01 00:00:00' and updated_time <'2017-01-01 00:00:00';
+----+-------------+-------------------------------+------------+-------+---------------+---------+---------+------+-------+--------------------------+
(北联网教程,专业提供视频软件下载)
……