How do I reset a self-hosted WordPress URL?

The easiest way to do this is by using copy&replace in the SQL file. Export the database. Use your favorite text editor and do a copy&replace and import it into a new database.

Then you go to wp-config.php and you change the WP_HOME and WP_SITEURL to the new host. Then you change the databasename. You also need to ensure that the same db user has access to the database.

Btw: There is a separate stackexchange for wordpress. Check out How do I move a WordPress site to another server?

Related Posts:

  1. Multiple developers / editors working on a site in progress
  2. How can I make updates to a site, on a development copy, but then move updates back without overriding live site’s evolving database?
  3. Fastest way (least amount of steps) to locally import a remote database using WP-CLI
  4. Solution for database version control and deployment?
  5. How to migrate a HTTPS WordPress installation to localhost?
  6. How can I migrate from another platform to WordPress (using the same domain) and launch when ready?
  7. Migrating data between local and development server
  8. Best way to import users, post and categories from an external database
  9. Syncing local content with development / staging sites
  10. Organizing WP Pages based on old website database
  11. Presentation vs Content in WP DB-Tables
  12. Migrating non-WordPress CMS to WordPress, lots of data to move — possible solutions?
  13. Migrate a Non WordPress database to wordpress [closed]
  14. Weird issue with database migration and SSL links
  15. How to fix unchanged URLs in Database after running serialized search and replace script?
  16. Migrating database / content of non-CMS site to WordPress
  17. I don’t see site_url and home_url fields in wp_options table (phpMyAdmin)?
  18. Export all content from wordpress
  19. Migrating WordPress from DreamHost to Azure WordPress Resource via UpdraftPlus “wp_options table does not exist…” error
  20. Moving minor updates between local and live sites – just database?
  21. How to move the WordPress site Layout from test site to Production site?
  22. Merging two databases without borking it
  23. Why does importing copies of the database dump and the document root make WordPress data inconsistent?
  24. Able to use all admin pages but in the frontend there is a “Error establishing a database connection”-Error
  25. Trouble Migrating all data blog from WordPress.com to WordPress.org
  26. Copying database tables to new database
  27. Migrating from PDO using SQLite to clean new install using MySQL
  28. Migration: Copying database content to a different server
  29. Change WordPress URL in sql file via Terminal
  30. Strange characters added to the database
  31. After database migration, theme mods don’t show [closed]
  32. Problem migrating to localhost
  33. WordPress url transformation script
  34. How to transfer from localHost to live but use the already existing database on the server?
  35. Image link issues after importing a database backup to my local web server
  36. Database migration issues – Error #1046 No database selected
  37. echo site_url() returns a different value than what is in the database siteurl field
  38. Migrate Users From laravel to wordpress
  39. /wp-admin not accessible after migrating to local host (no plugin issue)
  40. How to fix Uploaded to this post option to see group of images uploaded to a post?
  41. How do you enable scripts on a WordPress installation in Softaculous?
  42. WordPress site migration – locked out of admin area
  43. Malware in old website – how to migrate?
  44. WP website showing blank page after moving from subdomain to main domain
  45. WordPress Migration – Issue with admin panel changes
  46. Do I need to be selective about where I search and replace when pointing a domain to a subfolder used for development?
  47. How to edit posts/pages without making the change live?
  48. Migrate not successful, DB is broken. How to fix, or at least output static HTML without plugins?
  49. After Migration From dev, Only my Links to the Homepage Still Redirect to dev
  50. I cannot change anything in my wordpress database from within wordpress?
  51. Media library images “missing” after migrating them using SQL
  52. Restoring .sql backup results in “Error establishing a database connection”
  53. import (migration) user database to wp-users
  54. Database question while Migrating from one domain to another on same WebHost [Bluehost]
  55. Moving database from WP 2.6 to 3.5 problem
  56. Importing Concrete5 content to WordPress
  57. Getting an error when trying to migrate to DV server from Grid with Media Temple [closed]
  58. What is this JavaScript “require”?
  59. get_results using wpdb
  60. wpdb->insert multiple record at once
  61. How to monitor server for error establishing a database connection
  62. Default WordPress settings API data sanitization
  63. Fatal error: Call to undefined function dbDelta()
  64. Connect to remote database using Localhost install
  65. remove missing image attachments
  66. How to ensure data consistency in WordPress
  67. How to intercept update_option() before it saves data?
  68. wpdb query on custom table not working [closed]
  69. How to diagnose and keep in check encoding issues?
  70. wp_redirection_404 table has grown to 7GB
  71. Delete all post meta except featured image Using SQL
  72. How to interact with another wordpress install on same database?
  73. Saving into post_excerpt or post_content
  74. Maintain user profile data in a non-WordPress database
  75. Setup private content for specific users with daily updates [closed]
  76. Connection refused on locahost after importing database?
  77. creating new field on mysql
  78. Does WordPress store the username as a primary key in the database?
  79. WSOD 3.9.1 – Tried Everything so far
  80. SQL query to set posts in bulk based on the post content
  81. Automate WordPress website setup with prefilled data
  82. How do you render posts from outside wordpress?
  83. Fetch a single row from a custom table for to a given ID
  84. Database create or redirect
  85. Database structure cheatsheet
  86. How to escape percentage sign(%) in sql query with $wpdb->prepare?
  87. A WP dev site that displays content from a live site’s database but cannot write to wp_posts?
  88. error establishing database connection (WAMP + filezilla)
  89. Is there a way for two deferent themes to consume two different DB on a same WP instance?
  90. Auto populate form fields based on serial input or pull listings from other websites?
  91. How to extract some part of WordPress full source code
  92. Error establishing a database connection for some files
  93. Hash user emails in database?
  94. Weird characters in title if it contain “ ”
  95. Saving data to database and exporting to excel
  96. One information repeated on multiple locations on one site [closed]
  97. Showing Error(TAble already exist)
  98. wp-config was suddenly updated
  99. Order of search results based off of a backend custom field and also in alpha order
  100. How to find fresh (last modified) and sql backup?
techhipbettruvabetnorabahisbahis forumutaraftarium24edusedueduseduseduedusedusedusedusedus