GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

DB backup data older than 6 months

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • 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.

    Comment


    • #3
      Thanks for the update.

      Comment

      Working...
      X