How To Change WordPress Site Domain Name By Editing Its Database ?

We have already discussed about changing your website domain name or URL by editing functions.php file and by editing wp-config.php file. Now this tutorial explains you how you can update your website web address to new one (when you are migrating your website to a new domain) directly by updating your WordPress site’s MySQL database.

First of all open your web hosting account and then access your website database by logging-in to phpMyAdmin. Now follow the given steps:

  1. From the screen showing all your database tables look up for wp_optionsNote: The table prefix of wp_ may be different in-case you have changed it when installing.
  2. Click the small Browse icon.
  3. A screen will open showing a list of the fields within the wp_options table.
  4. Under the field option_name, scroll down looking for siteurl.
  5. Click Edit Field icon (usually present at the far left at the beginning of the row)
  6. The Edit Field screen will appear.
  7. In the input box for option_value, change the URL information to the new address.
  8. Verify and click Go for saving information.
  9. You should be returned to your wp_options table.
  10. Look for home field in the table
  11. Click Edit FieldNote There are several pages of tables inside wp_options. Look for the> symbol to page through them.
  12. From the input box for option_value, change URL information to the new address.
  13. Verify and click Go for saving information.

That’s all. Your website domain name is now updated to new one. If you face any problem then feel free to write it up in the following comments.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.