MySQL Forums
Forum List  »  Partitioning

Re: Backup and remove a partition?
Posted by: Mikael Ronström
Date: January 24, 2006 02:38PM

Jon Baer wrote:
> Hi,
>
> Ive started playing around w/ partition but when
> it comes to backing up a single partition (to
> disk/tar.gz/.zip) what is the best method to do
> this? Is there any refactoring that can happen?
> Example:
>
> p1, p2, p3, p4
> backup p2, remove
> p1, p3, p4
>
> Can p2 be placed back into the block w/ no
> downtime?
>

At the moment it is not possible to put back partitions that have been dropped into the
table. There has been discussions around supporting converting a table to a partition but
it has not been implemented. Thus data has to be reinserted again at the moment.

Rgrds Mikael

> Thanks.

Mikael Ronstrom
Senior Software Architect, MySQL AB
My blog: http://mikaelronstrom.blogspot.com

Options: ReplyQuote


Subject
Views
Written By
Posted
3259
January 23, 2006 09:49PM
Re: Backup and remove a partition?
2345
January 24, 2006 02:38PM


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.