Tutorial :mysqldump with partitioned table


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?


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

Note:If u also have question or solution just comment us below or mail us on toontricks1994@gmail.com
Next Post »