I am moving from one VPS to another. I went ahead and transferred all the php files over to the new VPS. I also uploaded a database back up just to ensure everything was up and running on the new host. I confirmed everything is ready to be used and all I need to do is update the dns servers for the domain. Whats the best way to prevent data loss while the DNS is propagating.
I had a theory but not sure it will work. I hope this makes since.. I was thinking of telling the new server to read from the database on the old server, give it 2 days to make sure the DNS has propagating, close the site for 20-30 minuets while I grab a db back up and transfer it to the new host, reconfigure the site to read off the database on the new server. Then reopen with only about 30 minuets of down time and no data lost.