MySQL Forums
Forum List  »  Partitioning

Re: Backup one partition of a table
Posted by: Mikael Ronström
Date: May 03, 2006 12:44AM

Hi,

Jens Beier wrote:
> Hi,
>
> is it possible to backup only one of several
> partitions of a table?
> If so, how can I do this?
>

There are no particular backup-specifics for partitioning. However if you
use a backup method that uses SELECT queries you can always ensure that you
only backup certain partitions by choosing a proper WHERE clause.

Rgrds Mikael

> regards Jens

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

Options: ReplyQuote


Subject
Views
Written By
Posted
3417
April 19, 2006 03:15AM
Re: Backup one partition of a table
2131
May 03, 2006 12:44AM


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.