DB backup data older than 6 months

  • Filter
  • Time
  • Show
Clear All
new posts

  • DB backup data older than 6 months

    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.

  • #2
    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.


    • #3
      Thanks for the update.