Not the answer you need?
Register and ask your own question!

DB backup data older than 6 months

krishnakrishna ContributorInactive User Role Beginner
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.

Comments

  • przemekprzemek Percona Support Engineer Percona Staff Role
    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.
  • krishnakrishna Contributor Inactive User Role Beginner
    Thanks for the update.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.