MySQL Forums
Forum List  »  Partitioning

Moving partitions
Posted by: Dominique Karg
Date: March 04, 2008 12:10PM

This would be my last question for today, but I couldn't find a short answer either searching the forums.

Is it possible to somehow move all the data from a partition from one table to another, or even into another database ?

On a filesystem a "mv" is much faster than a "cp;rm", so I thought this might be the case here too.



Options: ReplyQuote

Written By
Moving partitions
March 04, 2008 12:10PM
March 25, 2008 10:58AM

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.