How to stage a redesigned site on a new webhost while the original site is still live? [closed]

SO FINALLY to my question: Is this indeed a brilliant solution, or is there a real possibility it will it cause me major problems like broken links and database corruption in the future?

You will find that new content created refers to the new URL, even after you remove the config statements, and old content may still refer to the original URL.

So yes, it will cause problems. You can’t change a sites URL by adding defines to the config file, the database needs migrating too with an appropriate search replace tool. ( an SQL query is not that tool ).

There are many ways to achieve your goal, this is not it.

Related Posts:

  1. Publishing WordPress from stage to production server
  2. Proper way to have multiple installs with a single database
  3. Plesk login inaccessible after changing site URL
  4. Change of “home” results in timeouts (only on index.php)
  5. Best practice for versioning wp-config.php?
  6. Password in wp-config. Dangerous?
  7. What’s the difference between WP_MEMORY_LIMIT and WP_MAX_MEMORY_LIMIT?
  8. Turn Off Automatic Trash Deletion?
  9. How can I change preview URL?
  10. Override the wp_siteurl and wp_home not work
  11. Changing WP_CONTENT_DIR and WP_CONTENT_URL in wp-config.php does not register?
  12. Missing a temporary folder despite settings in wp-config.php
  13. How to use live images on local install?
  14. Syntax of FS_CHMOD_DIR and FS_CHMOD_FILE
  15. WordPress PHP error handling and reporting in production environment
  16. Declaratively Configuring WordPress in XML or JSON or YAML
  17. WP_MEMORY_LIMIT didn’t work in wp-config
  18. Fatal error: Allowed memory size of 41943040 bytes exhausted (tried to allocate 20480 bytes)
  19. How to set up gmail SMTP in WordPress
  20. error:-Cannot modify header information – headers already sent by
  21. Changing HTTP URL Port
  22. wp-config.php file permissions
  23. How to update WordPress from the latest trunk
  24. how to use is_admin in wp-config.php
  25. Locked out of WordPress Site Admin after enabling Force SSL on WordPress Https (SSL)
  26. Set wp-content folder to Dropbox folder
  27. Best practice differences in DB options and wp-config between live, staging and local WordPress environments?
  28. Including a 3rd party library in WordPress which needs to be accessible by wp-config
  29. wp-config.php being deleted
  30. Get WP CLI to hide debug warnings and notices in JSON output, same setting as website
  31. Installation Issue WordPress locally – The file ‘wp-config.php’ already exists
  32. What is this file: wp-config-wpe.php?
  33. Putting my site live
  34. enable SFTP via SSH keys in wordpress
  35. html lang=”” instead of lang=”en-us” – why?
  36. Why do I get a WAMP homepage when clicking on specific website’s URL on LocalHost?
  37. Creating the wp-config.php file manually
  38. What Does this Code Snippet Do?
  39. WP_Debug not displaying anything
  40. Can I delete `wp-config-sample.php` after installing and configuring WordPress?
  41. When clicking on “home” page from any other page, it goes to IP address and my website doesn’t load
  42. How to reliably set file/folder permissions?
  43. Multiple wp-config.php files in one home directory
  44. Why edits to wp-config.php must come before “That’s all” comment
  45. error log cluttered with undefined DB_USER wp-admin/setup-config.php
  46. wp-config dynamic hostname in WP_HOME and WP_SITEURL
  47. Is it possible to override the ABSPATH constant
  48. How to stop fatal error when loading theme template file directly
  49. Force WordPress to load from site’s hostname
  50. Should I change wp-config for SSL?
  51. Out of memory errors : how best to track them down
  52. Localhost to Staging to Development Dynamic WP-CONFIG
  53. Redefine cookie domain for subdomains
  54. multiple language directories
  55. Error in database connection [closed]
  56. Update wp-config.php and lost pages
  57. blog url redirecting
  58. Conflict with wp_homeurl, wp_siteurl and admin interface settings
  59. Redirect to another page using contact form 7? [closed]
  60. error messages in dashboard login
  61. where should I write constants in wordpress?
  62. Issues copying site into local machine
  63. Autosave interval remains default despite wp-config.php defines
  64. Carriage Return control character (^M) found in wp-config-sample.php
  65. Are the wordpress settings (abspath, disable core updates) added by SiteGround of any use after I’ve migrated to a different host?
  66. Need help fixing my wp-config file [closed]
  67. Why was my new WordPress installation’s config page publicly viewable when first installed?
  68. WP_MEMORY_LIMIT didn’t work in wp-config, only within default-constants.php
  69. Cookie set without HttpOnly flag
  70. Changing the wp-config.php broke the site
  71. Define option outside wp-config.php (on WordPress.com)
  72. Site lost all formatting when I attempted to migrate to Bluehost [closed]
  73. Moving wp-config.php one level up – 500 error – Nginx [closed]
  74. How can I configure an SMTP Server?
  75. What should index.php contain on Synology NAS to get external access to WordPress to work?
  76. Remote server does not read `WP_HOME` from wp-config.php when local server does
  77. Cannot access WordPress website from external IP while internally it is working properly [closed]
  78. IP addresses to block to stop WP auto-update?
  79. Concerns over wp-config file [closed]
  80. Site Address and WordPress Address settings when using a load balancer
  81. Not showing old migrated content in website
  82. How to rename the wp-config.php file once under version control?
  83. Read wp-config without loading the rest of WordPress – i.e. wp-settings, etc
  84. How turn on error reporting without reset?
  85. WordPress installed on a Sub-directory
  86. Editing wp-config.php file asks for another installation
  87. $post->id vs $post->ID problem after using WordPress config bootstrap
  88. ABSPATH not defined?
  89. WordPress login redirection not working on Nginx root directory
  90. Need help re-connecting local WP-config file to local database
  91. Domain not redirected correctly with WordPress Multisite
  92. wp-config.php randomly will reset to wp-config-sample.php
  93. WP_SITEURL vs WP_HOME link output
  94. What can an attacker do if he has access to my wp-config file?
  95. How to fix wp-login.php gives error 500 after migration?
  96. Change default wordpress FS owner
  97. Define new constants in wp-config
  98. sudden changing of host IP result in crash of the site
  99. Move wp-content outside root
  100. Can you define readability settings in wp-config.php?
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)