Moving WordPress site/blog to a new domain or location

Recently, I was hire to move WordPress site/blog to a new hosting

These SQL statement help me when page and post did not show up on the new host

UPDATE wp_options SET option_value = replace(option_value, ‘http://www.old-domain
.com’, ‘http://www.new-domain.com’) WHERE option_name = ‘home’ OR option_name = ‘siteurl’;

 

UPDATE wp_posts SET guid = replace(guid, ‘http://www.old-domain.com’,'http://www.new-domain.com’);

 

UPDATE wp_posts SET post_content = replace(post_content, ‘http://www.old-domain.com’, ‘http://www.new-domain.com’);

Where do I run the SQL script?

Every WordPress site/blog uses a MySQL Database which can be accessed through your phpMyAdmin even if you are not using cPanel hosting. Login to MySQL database that houses WordPress tables via phpMyAdmin or login to the DB server and runMySQL client as root.

No confidence of moving WordPress site/blog to a new domain or location?

Not sure what I am talking about? Hire me and let me solve this tricky WordPress migration. Contact me mryap [at] ymail.com