wordpress database restore – broken link

It sounds like you probably need to go into the wp_options table and change the rows ‘site_url’ and the ‘home_url’ to match up with the new location. site_url is on the first page of the wp_options table, and ‘home_url’ is on the second page.

If you can access the wp dashboard those can be changed in the 3rd and 4th text boxes on the Settings >> General admin screen.

Related Posts:

  1. What’s the simplest way to backup my WordPress database?
  2. Does wpdb add considerable overhead on queries with large result sets?
  3. Faulty restore of the database, encoding issue
  4. WordPress and automated MySQL backups to a different host
  5. Backup another database with BackUpWordPress plugin [closed]
  6. Why are no posts showing despite my apparently correct DB restoration?
  7. For WordPress is there content in the database which I can safely ignore?
  8. What happens if I overwrite the current wp_options table with a backup from a week ago?
  9. Why does importing copies of the database dump and the document root make WordPress data inconsistent?
  10. Store partial database to an archive database time to time
  11. Where is phpMyAdmin inside WordPress?
  12. How To Run A Temporary Instance Of a WordPress Backup Without a Database?
  13. How to backup my site and restore my wordpress site
  14. Cannot restore wordpress database from sql dump [closed]
  15. restore a db after bad backup
  16. Backing up WordPress database and files
  17. How can i restore a WordPress site with the DB and WordPress Files
  18. How do you enable scripts on a WordPress installation in Softaculous?
  19. SQL database import #1046 error
  20. is it possible to install new WordPress in an old WordPress folder?
  21. Is it possible to separate databases in WordPress site – one for orders and the other for all non-orders related
  22. WPCLI search and replace in a particlar site dir effect another site-dir
  23. How do I find out from my database what version of WordPress I need?
  24. Backup Restore turns carriage returns to literal strings
  25. I have a WordPress 4.6 database dump – how do I use it in a new install?
  26. Copy WordPress to new directory
  27. Find/ascertain latest wordpress db from multiple database copies
  28. version control for wordpress? (wordpress folder and database at same time)
  29. What’s the cleanest way to transfer WordPress to a new server
  30. What is the difference between an ORM and an ODM?
  31. Checking if Database Table exists
  32. How To Export/Import WordPress (MySQL) Database Properly Via Command-Line?
  33. Is it possible to define two databases for one installation?
  34. Syncing local content with development / staging sites
  35. Export WP database for import using WP-CLI on Vagrant Box
  36. Improve or optimize a very slow query
  37. What is the advantage of separating wp_users and wp_usermeta table?
  38. “MySQL server has gone away” since update to 3.8
  39. WordPress page title repeated in SOME pages
  40. How to correctly add a table to the WordPress MySQL database
  41. MySQL Syntax Error upon restoring database from backup [closed]
  42. Help running a MySQL query to update all wp_#_options tables in a Multisite install
  43. Merge two databases: OLD SITE -> NEW SITE
  44. Is it safe to convert tables from MyISAM to InnoDB?
  45. Use one WordPress database with multiple instances of one site
  46. Who is responsible for data sanitization in WordPress development?
  47. How do I properly update the WordPress database password?
  48. How to check if a core update, like 4.9.8 → 5.0, involves a database update (migration)?
  49. I need to get an array from the wordpress database
  50. Moving minor updates between local and live sites – just database?
  51. what is the best way to store user created data?
  52. Using GROUP CONCAT in my-sql query with wp_usermeta table
  53. input data and output table [closed]
  54. How to move the WordPress site Layout from test site to Production site?
  55. Your PHP installation appears to be missing the MySQL extension which is required by WordPress
  56. Retrieve data from the database to table such as comments in the admin control panel
  57. Need to store custom user information (many-many relationsips), preferably not as user meta
  58. charset problem with new custom table
  59. WordPress and user security
  60. How to share plugin created database tables between two WordPress sites
  61. How to connect to a remote database in WordPress?
  62. Migrating from PDO using SQLite to clean new install using MySQL
  63. Change WordPress URL in sql file via Terminal
  64. $wpdb->insert Giving duplicates
  65. What can I do when an outside party hacks into my weblog and changes my display name?
  66. How to delete database without using any plugin?
  67. WooCommerce: remove sample & dummy data
  68. Is database deleted on clicking “reinstall” button in WordPress updates?
  69. AJAX wp-mysql running too slow
  70. Delete/Replace words from X to Y in post content
  71. How get Data form wordpress database as array not stdclass?
  72. Multiple WordPress sites installs sharing the same database but with different content and domains
  73. Brandoo WordPress Unable to Update to WordPress 4.2.2
  74. Remote database -> massive response time increase?
  75. Custom Post Type not showing anything added by code anymore?
  76. How do I have a user upload a blog post and then retrieve that to display in a card on the site?
  77. Delete user with only subscriber role
  78. How to rename custom table name programatically in wordpress?
  79. How to edit custom table data in frontend
  80. pre_get_posts causings DB error when using ( ‘posts_per_page’, -1)?
  81. generate PDF from member information
  82. mysqli_query(): MySQL server has gone away for Curl Request
  83. Help posting values to DB on submit using $wpdb->query
  84. WP website showing blank page after moving from subdomain to main domain
  85. create a table using user meta custom data
  86. wpdb query to insert images in to post/page gallery
  87. Creating a database in my plugin not working
  88. How to create index (sql) to a meta_key?
  89. get_user_meta and umeta_id
  90. Send data to database after redirect (and popping out of iframe)
  91. Simple email input store in database
  92. Pulling values from a sepcific row in table
  93. import (migration) user database to wp-users
  94. What is best for saving lot of extra detail of user?
  95. Insert Extra fields added in the front end registration form to DB
  96. $wpdb->insert not working for last select option
  97. How to create a table [closed]
  98. WP Multisite Users Not Linking
  99. Query a meta key using an array of values where the database value is a string
  100. Restore posts, but only posts that exist in my database backup