Re: Backup and remove a partition?
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
Subject
Views
Written By
Posted
3601
January 23, 2006 09:49PM
Re: Backup and remove a partition?
2614
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.