MySQL Forums
Forum List  »  Partitioning

Re: How to make a backup from a partition
Posted by: Phil Hildebrand
Date: May 05, 2008 11:55AM

I don't believe there is a specific tool that you could give a partition name to, but there are a couple ways:

You could use mysqldump with --tables and --where="partition key=x"

where the partition key is the full set of values for a given partition. The optimizer should recognize it and only scan the given partition.

You could use select into outfile in the same way (have the where clause define the full set of values for the given partition).

I think it would also be possible with MyIsam to lock the table (would lock all partitions) and then copy the given partition name file at the os level), but I don't think you could use mysqlhotcopy because I think it's table level with respect to granularity.

Options: ReplyQuote

Written By
Re: How to make a backup from a partition
May 05, 2008 11:55AM

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.