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: 193

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

Related posts about mysql

Related posts about database