Migrate servers without losing any data / time-limited MySQL dump?
Posted
by inac
on Server Fault
See other posts from Server Fault
or by inac
Published on 2010-06-11T14:31:35Z
Indexed on
2010/06/11
14:33 UTC
Read the original article
Hit count: 191
Is there a way to migrate from an old dedicated server to a new one without losing any data in-between - and with no downtime? In the past, I've had to lose MySQL data between the time when the new server goes up (i.e., all files transferred, system up and ready), and when I take the old server down (data still transferred to old until new one takes over). There is also a short period where both are down for DNS, etc., to refresh.
Is there a way for MySQL/root to easily transfer all data that was updated/inserted between a certain time frame?
© Server Fault or respective owner