I'm asking if it's possible in MySQL to export just rows modified in a period of time for example in the past month, if it is possible, how?
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
This would depend on the table having a timestamp column.
If you have a table called
You could specify the date range on that table as follows (for June 2013):
This would be most helpful since timestamps can be updated automatically.
I wrote a post on
If you do not have a timestamp column in the desired tables, you are better of just keeping all binary logs generated during any given month.