Changes between Version 4 and Version 5 of Partition

Timestamp:

06/15/22 13:53:09 (2 years ago)

Author:

krit

Comment:

--

Partition

@@ -52 +52 @@
 
 }}}
+
+5. Archive partition base on [https://mysql.dbgeekgirl.com/2018/12/exchange-partition-archiving-strategy.html here]. First, we create a table like payments2
+{{{
+mysql> create table payments_2004 like payments2;
+}}}
+
+6. We remove partition from new table that we create
+{{{
+mysql> alter table payments_2004 remove partitioning;
+}}}
+
+7. We move partition of payments2 to payments_2004
+{{{
+mysql> alter table payments2 exchange partition p2004 with table payments_2004;
+}}}
+
+8. To move back from payments_2004 to partition p2004 in payment2
+{{{
+mysql> alter table payments3 exchange partition p2004 with table payments_2004;
+}}}
+