Re: How to make a backup from a partition

[Phil Hildebrand]

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.