# MySQL Backup of table partioning

**URL:** <https://forums.percona.com/t/mysql-backup-of-table-partioning/1674>\
**Category:** Other MySQL® Questions\
**Created:** [September 22, 2011, 12:14am UTC](https://forums.percona.com/t/mysql-backup-of-table-partioning/1674 "2011-09-22T00:14:47Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![ervaneet82](https://avatars.discourse-cdn.com/v4/letter/e/c68b51/32.png) [@ervaneet82](https://forums.percona.com/u/ervaneet82)\
**Post date:** [September 22, 2011, 12:14am UTC](https://forums.percona.com/t/mysql-backup-of-table-partioning/1674/1 "2011-09-22T00:14:47Z")

</div>

Hello All,

My Question is very simple.

I want to take the backup of mysql table who has partitioning, main issue is that I want to backup partition by partition say I have p0, p1 , p2 partition. I want take the backup of p0 only.

In RANGE partition it is very easy , but I want in hash partitioning and list partitioning.

Below is the example of RANGE partition :-  
mysqldump --user=username --password=password --no-create-info --where=" YEAR(joined) \< 1960" test members \> test.members.p0.sql

But how to take backup of hash and list partition by partition.

Kindly help me out.

Thanks & Regards

Vaneet Gupta

---

<div class="post-metadata">

**Author:** ![sterin71](https://avatars.discourse-cdn.com/v4/letter/s/5e9695/32.png) [@sterin71](https://forums.percona.com/u/sterin71)\
**Post date:** [September 23, 2011, 5:46pm UTC](https://forums.percona.com/t/mysql-backup-of-table-partioning/1674/2 "2011-09-23T17:46:39Z")

</div>

This sql query should solve it for you.

It creates mysqldump commands with --where arguments that singles out data from each partition. I haven’t tested it myself though.