Moving a site from a temporary domain to the live domain [duplicate]

So basically you want to change the URL from subdomain to main domain in your DB so that it will work with your main Domain.

What I do is I use search & replace DB script and in this I will enter my subdomain to search and to main domain to replace.

You can download that script from here and keep the PHP file in the server.
https://interconnectit.com/products/search-and-replace-for-wordpress-databases/

Thanks

Related Posts:

  1. What is this JavaScript “require”?
  2. How to resolve ORA-011033: ORACLE initialization or shutdown in progress
  3. Oracle SQL query for Date format
  4. Using wpdb to connect to a separate database
  5. How can I make updates to a site, on a development copy, but then move updates back without overriding live site’s evolving database?
  6. How can I make a WordPress database portable and url independent?
  7. wpdb->insert multiple record at once
  8. How to migrate a HTTPS WordPress installation to localhost?
  9. Database connection close
  10. How to stop WordPress using utf8mb4_unicode_520_ci collation?
  11. How to monitor server for error establishing a database connection
  12. Importing posts from old website to new conflicting post ID’s?
  13. Exporting revisions
  14. WP_Options ID high
  15. Default WordPress settings API data sanitization
  16. Fatal error: Call to undefined function dbDelta()
  17. Connect to remote database using Localhost install
  18. How to use multiple database in wordpress?
  19. How to ensure data consistency in WordPress
  20. Is removing orphaned wp_postmeta records safe?
  21. How to intercept update_option() before it saves data?
  22. wpdb query on custom table not working [closed]
  23. What ALL can cause “Another update is currently in progress.”? [closed]
  24. Error connecting to DB in /wp-includes/wp-db.php on line 1538 [closed]
  25. Set Display Name to first and last name (phpmyadmin SQL Query)
  26. How to fix unchanged URLs in Database after running serialized search and replace script?
  27. Trigger Plugin database update after git pull
  28. How to query the WordPress database to get posts of a certain custom post type, taxonomy and field?
  29. Extracting the post_id via the wp_insert_post action (external db query)
  30. How to interact with another wordpress install on same database?
  31. Are custom tables in the database overwritten when WordPress is updated to new versions?
  32. What is the proper way to validate and sanitize JSON response from REST API?
  33. How do I get the posts within a certain year/date(with sql query)?
  34. batch UPDATE autoload value in wp_options table
  35. Displaying BLOB PDF File
  36. Saving into post_excerpt or post_content
  37. Maintain user profile data in a non-WordPress database
  38. How to fix the disappearance of the “\” character when updating a post in the database
  39. Data storage for JS app using WP REST API
  40. WP CLI Core install – blank database
  41. Update from 4.5 to 4.6 failing
  42. Setup 3 Sites To Connect To 1 Database and Share Data
  43. How can I push local database changes to production, without impacting recent posts/pages that were published on production server?
  44. Setup private content for specific users with daily updates [closed]
  45. Does auto_load to ‘no’ in wp_options improve performance
  46. Call to undefined function get_user_meta() – trying to access data in MySQL from custom fields
  47. Will there be any concern if I upgrade my current WordPress Database server from Centos 7 Mariadb 5.5 to Centos 8 Mariadb 10.3?
  48. In which format the data is stored in WordPress Databases?
  49. Is it possible to rebuild the website while not accesseing the original database?
  50. Error message on blog posts only on my local environment [closed]
  51. how to read database fields
  52. $wpdb->query can’t insert data
  53. WSOD 3.9.1 – Tried Everything so far
  54. Can you refresh ONLY the wordpress adminbar and not the whole page?
  55. After database migration, theme mods don’t show [closed]
  56. Sending posts from Python to WordPress
  57. Problem migrating to localhost
  58. Remote database connection and local development
  59. How can I detect right db type?
  60. Add search bar to Custom Database Table in WordPress Dashboard
  61. Design problems when exporting remote database for local development
  62. How do you render posts from outside wordpress?
  63. A change in URL slug in database returns 404, how can I do auto-redirect?
  64. Second ezSQL initialization for MSSQL
  65. Fetch a single row from a custom table for to a given ID
  66. Database create or redirect
  67. Displaying table data on a page
  68. muliple wordpress installs (network) on different databases
  69. Database structure cheatsheet
  70. White Screen in Home Page
  71. Continuous SQL query errors from outside source
  72. How to escape percentage sign(%) in sql query with $wpdb->prepare?
  73. Whats the best practise on how to store json data from a custom settings page?
  74. Recovery – Restore Database after moving folder location locally
  75. Migrate Users From laravel to wordpress
  76. WordPress has been updated! Before we send you on your way, we have to update your database to the newest version
  77. Job and Employee Performance Tracking with Product Safety
  78. how add more field to wp user and save it to database
  79. How do I cleanup my database with data that is no longer being used?
  80. Malware in old website – how to migrate?
  81. Set SQL_BIG_SELECTS and MAX_JOIN_SIZE on a WP_Query
  82. How to optimize wp_option table?
  83. How to display $wpdb->insert_id; value on redirected page
  84. Database for JQuery Autocomplete field
  85. Should I Use only wpdb Class to Write Custom Queries?
  86. Auto populate form fields based on serial input or pull listings from other websites?
  87. Catchable fatal error in formatting.php
  88. Wrong url for the images while using same database for two WordPress installations
  89. Sending WordPress database information to cross domain the safe way?
  90. Database Name Change
  91. Weird characters in title if it contain “ ”
  92. Where To Find bb_profile_data(); In bbPress?
  93. One information repeated on multiple locations on one site [closed]
  94. Attach posts based on category and position
  95. Showing Error(TAble already exist)
  96. SQL query to rewrite all media URLs to end with .webp
  97. wp-config was suddenly updated
  98. Many images in wp-content/uploads folder that are not in Media Library
  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?
error code: 523