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.
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.
Thanks for the update.