Tutorial :mysqldump with partitioned table



Question:

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?


Solution:1

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
Previous
Next Post »