How to Migrate or Configure WordPress Database from one hosting Server to another Server?

  • Home
  • Technical
  • How to Migrate or Configure WordPress Database from one hosting Server to another Server?
Nov 2, 2021

In this article, I will show How to Migrate or Configure WordPress databases from one hosting Server to another Server?

Here I am only showing Database Configuration

  • First, you have to export Database from the existing hosting server.
  • Import .sql file into your new hosting Server.
  • Login to your PhpMyadmin and Update the table.
UPDATE wp_posts SET guid = REPLACE(guid, 'oldurl.com', 'newurl.com') WHERE guid LIKE 'http://oldurl.com/%';
  • oldurl.com – Previous URL shown in WordPress settings > general options
  • newurl.com – New URL
UPDATE `wp_posts` SET guid = REPLACE(guid, 'oldsiteurl', 'newsiteurl') WHERE guid LIKE 'oldsiteurl%';

UPDATE `wp_postmeta` SET meta_value = REPLACE(meta_value, 'oldsiteurl', 'newsiteurl') WHERE meta_value LIKE 'oldsiteurl%';

UPDATE `wp_options` SET option_value = REPLACE(option_value, 'oldsiteurl', 'newsiteurl') WHERE option_value LIKE 'oldsiteurl%';

If you got any plugins that do redirections you should also change the permalinks there:

UPDATE `wp_redirection_404` SET url = REPLACE(url, 'oldsiteurl', 'newsiteurl') WHERE url LIKE 'oldsiteurl%';

UPDATE `wp_redirection_404` SET url = REPLACE(url, 'oldsiteurl', 'newsiteurl') WHERE url LIKE 'oldsiteurl%'

Leave a Reply