'Is it possible to mysqldump with partition() in mysql?

I have to dump large amount of tables with different partition keys.

So if I can dump tables using partition() it would make my job slightly easier.


I'm currently doing like this :

mysqldump $DB_NAME $TB_NAME --where="${part_expr} >= '${part_cnd_from}' and ${part_expr} < '${part_cnd_to}'" > ${backup_path}

And I'm wondering if I can do something like this

mysqldump $DB_NAME "$TB_NAME partition(${partition_name})" > ${backup_path}


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source