Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question

If you can run the servers in parallel, setup the old MySQL as a replication master, the new as a slave. Once the new server is running and sync'ed to the master, switch your DNS.

share|improve this answer
They're in different data centers, transferring to a different dedi host - would this still work? do you know of a better guide on this than ? – inac Jun 12 '10 at 4:15
Yes this would work you will still need down time to make sure that there is no new data on the old server before you bring the new server to live or you could have duplicate content (ie primary keys). I did this and we managed to only have the site down for the prorogation time of dns – Alistair Prestidge Jun 16 '10 at 16:41 is the latest for version 5.1.x – Craig Jul 2 '10 at 16:02

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.