Re: Backup a partition to archive.
Posted by:
Rick James
Date: November 01, 2009 11:26AM
mysqldump can be given a where clause. Use that to specify exactly all the oldest partition.
Recommend you verify that you got the right stuff. This could be done by loading it into a different database & table. Then compare (at least) the number of rows. Maybe also compare the MIN and MAX values for the field controlling the partitioning.
Subject
Views
Written By
Posted
3766
October 30, 2009 11:32PM
Re: Backup a partition to archive.
2683
November 01, 2009 11:26AM
2263
November 01, 2009 02:39PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.