# DB backup data older than 6 months

**URL:** <https://forums.percona.com/t/db-backup-data-older-than-6-months/3191>\
**Category:** Other MySQL® Questions\
**Created:** [January 9, 2014, 3:58pm UTC](https://forums.percona.com/t/db-backup-data-older-than-6-months/3191 "2014-01-09T15:58:00Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![krishna](https://avatars.discourse-cdn.com/v4/letter/k/71c47a/32.png) [@krishna](https://forums.percona.com/u/krishna)\
**Post date:** [January 9, 2014, 3:58pm UTC](https://forums.percona.com/t/db-backup-data-older-than-6-months/3191/1 "2014-01-09T15:58:00Z")

</div>

We have many databases in a host. Would like to take one specific DB backup with the data older than 6 months from it. I am aware to take the dump of a table with specific data older than months or based on a condition as per the fields available in the table. But can we take the DB dump from which all the tables in the DB should have exactly 6 months old data using mysqldump command.

---

<div class="post-metadata">

**Author:** ![przemek](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/przemek/32/3_2.png) [@przemek](https://forums.percona.com/u/przemek)\
**Post date:** [January 12, 2014, 1:10pm UTC](https://forums.percona.com/t/db-backup-data-older-than-6-months/3191/2 "2014-01-12T13:10:50Z")

</div>

It would be possible if you had the same kind of timestamp column, with the same name, in all the tables. Then the --where option would be used for each dumped table. Otherwise you need to dump each table separately creating --where option accordingly.

---

<div class="post-metadata">

**Author:** ![krishna](https://avatars.discourse-cdn.com/v4/letter/k/71c47a/32.png) [@krishna](https://forums.percona.com/u/krishna)\
**Post date:** [January 15, 2014, 7:12pm UTC](https://forums.percona.com/t/db-backup-data-older-than-6-months/3191/3 "2014-01-15T19:12:16Z")

</div>

Thanks for the update.