Wordpress Change Domain Mysql Query

And paste this into the window in fig 3.

Wordpress change domain mysql query. It s used to uniquely id the post as the id can change if the posts are being exported imported into a new database. The left panel list all of your databases. A protip by mattchu about sql domain phpmyadmin and wordpress.

Here s what you need to do. Once you ve entered the new domain in the proper format click go at the bottom. After struggling to do research on google i found the steps below that save a lot of time.

When moving wordpress websites from one domain to another this tool is a great time saver. To do this use the phpmyadmin tool available in your site tools. Changing the guid will effectively republish all your articles.

Select the one connected to your wordpress site and head to the sql tab. Reading table information for completion of table and column names you can turn off this feature to get a quicker startup with a welcome to the mysql monitor. There are few ways to change the domain name on your wordpress application.

You just need to replace your site url from old domain name to new domain then execute the query on the mysql using phpmyadmin. For more reference you can read this tutorial. Sql queries to change wordpress website domain.

Once you have located the url entries to change click the edit option on the left for each entry to enter your new domain. Change the siteurl and home options in your wordpress database. Don t ever change the guid even if going to a new domain.