Click to See Complete Forum and Search --> : Migrating your live database


cancer10
11-23-2011, 09:27 PM
Hi People,

I am not too sure if this is the correct section to post this. (Mods pls move this to the appropriate section if not)

This is a common scenario when you need to move your live website which has a good amount of traffic all the time to a new server. How do you manage to move the db WITHOUT locking the db or putting up a "site under maintenance" page and loosing any data?

Whats the best approach assuming the db server is on the same web server ?

Thanks in advance