Hi, 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?
A:
You'll probably need to use select statement, because mysqldump has no way to know the name of the partition.
yoda
2009-11-29 18:02:38
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
2009-11-30 04:46:00
No, but you wont need that. Just use select statement like this example : http://www.liamdelahunty.com/tips/mysql_select_into_file.php
yoda
2009-12-01 22:36:34