Strategies for rotating backend production MySQL data into a test environment
Plan A:  Have the Production system be a Master; have another machine (or two) be a Slave.  At any moment, you could use the Slave (in a couple of different ways) to provide a snapshot of Production at some point in time.  The impact on the Master (Production) is zero (after a somewhat painful setup).  Master-Slave is the beginnings of any HA (High Availability) solution.

Plan B:  Use LVM (Logical Volume Management, an OS tool) as a way of taking a snapshot of the Production machine.  This involves taking down the server briefly (about a minute, regardless of amount of data).  Them the disk can be copied to elsewhere for whatever use -- such as building a dev box.

Neither of those do what I think of as a "rotate", but perhaps they solve your request?

I suggest you search for either or both of those strategies, then come back for further questions, if needed.