27th May 2022 at 12:56 pm #6399Mark.DunstanParticipant
I am planning to move my whole website to a more reliable server. Is this likely to cause any difficulties e.g. with data migration / the app / the Google Maps link? If so, do you have any advice to overcome or avoid those challenges?
Mark27th May 2022 at 1:16 pm #6400Andy MoyleKeymaster
If you are keeping the same URL when migrating there should be no issues.
Depending on how you do it, if people make edits during the first 48hours it may be saved on the old server not the new one.
There’s a way they can do it where you set up on the new server and then get the DNS records pointing to the new one from the old one. But there’s still a lag as the internet updates itself.
If you are changing URLs you will need to let me know for the app. And…
When you do the database move, there’s a couple of queries to update the database that can be done to smoothly migrate WordPress to the new URL. If you have access to PHPmyAdmin you can do them…
UPDATE wp_options SET option_value = replace(option_value, "http://www.oldsiteurl.com", "http://www.newsiteurl.com") WHERE option_name = 'home' OR option_name = 'siteurl';
UPDATE wp_posts SET guid = REPLACE (guid, "http://www.oldsiteurl.com", "http://www.newsiteurl.com");
UPDATE wp_posts SET post_content = REPLACE (post_content, "http://www.oldsiteurl.com", "http://www.newsiteurl.com");
UPDATE wp_postmeta SET meta_value = REPLACE (meta_value, "http://www.oldsiteurl.com","http://www.newsiteurl.com");
If the URL has changed you will need to update your Google API key restrictions as well *newsiteurl.com/*
Hope that helps – don’t know how techy you are! If you need to hire me to do the migration, get in touch!!!27th May 2022 at 2:22 pm #6403Mark.DunstanParticipant
Thank you, Andy,
The URL will be the same, so it sounds as if all will go pretty smoothly.
Thanks for the information about the possibility of user edits being lost (or located on the old server). I think I can manage that when it comes to it. (And I’ve got a proper techy person to do the migration, so we should be okay!)
I really appreciate your prompt and detailed response to this – thank you!
- You must be logged in to reply to this topic.