0

I have a large MyiSam table and I recently partitioned it. I backup the db every day usng mysqldump but rather than bakcup the entire large table, I'd like to just backup certain partition(s). Is there any way that I can specify which partitions to dump using mysqldump?

Chris Gerken
  • 16,221
  • 6
  • 44
  • 59
Russ
  • 115
  • 1
  • 2
  • 9

1 Answers1

0

You'll probably need to use select statement, because mysqldump has no way to know the name of the partition.

yoda
  • 10,834
  • 19
  • 64
  • 92
  • Is there any syntax like "Copy table" which copies just the partition that I want. From what I understand you can drop partitions like tables, is there any way you can replicate them like tables? – Russ Nov 30 '09 at 04:46
  • No, but you wont need that. Just use select statement like this example : http://www.liamdelahunty.com/tips/mysql_select_into_file.php – yoda Dec 01 '09 at 22:36