Don’t worry about changing the guid, you’ll be fine if you never update that field. The main places you’ll need to update are in the post_content column of wp_posts (for links and images), and in the wp_options table (for widget data).
Before you do any database replacing, though, read through this thread:
How to: Easily Move a WordPress Install from Development to Production?
There are some helpful tips there, and there are plugins that will do most of the work for you.
Related Posts:
- Moved WordPress to New Server, Now Tries to Download a File
- Migrating Markdown (from Drupal)
- Change site url when moving site to another url?
- Recover WordPress blog from an inactive domain name
- Is it possible just by using wp-cli to migrate one multisite instance to single site?
- Is there an easy way to migrate a site from SiteFinity to WordPress?
- How to transfer changes from test environment to live site?
- Migrate Changes from a Staging Site to Production
- Export and overwrite pages on import?
- URLs to images get messed up after migration
- What’s a better workflow for database migration?
- Does WordPress Import/Export tool actually exports media (images) as well?
- Links after moving my site to another domain
- Migrating my existing WP site to localhost
- Will post id change when migrating to new site?
- Critical Site Health Issue after WordPress Migration
- How do I redirect my blog posts to a subdomain?
- Migration / convert an existing site to WordPress
- Why isn’t my imported database showing up? install.php pops up and adds new tables to the database
- Install WordPress on new server or just copy old files?
- call_user_func_array() errors after migrating site with InstantWP
- We have a static Hugo website and we want to migrate it to WordPress
- How do I force password reset even with wrong password entered?
- How to copy WordPress live website to Bitnami stack localhost?
- Tags not importing when using WordPress import system
- Migrate from CMS Made Simple to WordPress
- Migrating entire online site to local server gives “The requested URL /login/ was not found on this server.”
- preventing the duplicate wp_insert_post
- Migrating wordpress multisite and domain mapping plugin
- Trying to move an Expression Engine site to WordPress, but not having luck with content
- Why is the domain name missing from the logout redirect?
- Migrate ProcessWire to WordPress
- Preserve password hashes when migrating to another server
- Automatic Maintenance Mode during All in One Port
- migrating my wordpress site
- Moving WordPress page to a new domain
- Is it possible to transfer my local installation entirely to the server?
- Why WordPress isn’t and/or can’t be domain agnostic
- migrated wordpress site not running properly, on Ubuntu localhost?
- Moving my newly made site from subdirectory
- What is the difference between wp-admin>Export>All content and MySql dump and import
- Clean private data (passwords, ftp, database) before zipping my site and SQL and give it to other person
- wordpress changing host breaks image links
- Tried to move blogs to a new server – “white screen of death”
- Blank screen after moving WordPress to new server with same domain name
- Moving Some Articles to new site
- I changed my domain name and REST API stopped working
- Getting HTTP error 500 after migrating a website
- How to perform User Migration?
- I’m hiding site with index.htm but now I can’t get to index.php
- WordPress migration to new domain and environment with only zip file
- Clone WordPress site from development server to live server
- Server Migration Issues
- Absolute Hyperlinks in WordPress Website Will Not Work In the Local Server
- Migrating WP website from local host
- After migration the website is really slow
- Migration of WooCommerce site
- How to remove symlink from folder
- Transfer WordPress
- Server ip to Domain
- Migrating from foo.com/wordpress/ to foo.com/ — how can I do it?
- Migrate VB.net website to wordpress website
- How do you do your big exports / imports?
- Import from Windows to Linux
- Wrong URL to CSS and JS after change domain
- Migrate site from local to local via a backup
- Migration from environment to master WordPress
- How to recover wordpress website moved from a PC to another
- Making a development site live, on Amazon EC2
- How can I migrate asp.net website to a wordpress site?
- How to move my website to wordpress?
- Update around 200,000 posts
- Migrate wordpress server to localhost problems
- Cannot combine two site’s pages together
- WordPress white screen
- Upgrading a wordpress site to its newest version
- Migration from XAMPP in windows to MAMP in Mac
- Internal server error
- Redirects and Subdirectory migration to Root Directory
- Moving WordPress site from local PC to local Mac
- WordPress giving gibberish and wp-admin gives HTTP 500 error
- Moved wordpress dashboard still pointing to testing server
- WordPress migration ended with 500 Error page on pages excluding homepage
- Authorization link broken when migrating from Blogger to WordPress
- Migrating a WordPress site has broken UTF8 encoding
- How to make Youtube short code transfer
- Migrating WordPress site from subdirectory to subdomain
- Error after moving wordpress blog
- Source code get entity escaped after migrating
- Fast way to copy a Blog x to another domain/server without deleting it
- Clone wordpress blog on localbox manually
- Migrated from localhost to server and cannot get custom_fields content anymore
- Can’t restore my wordpress site from zip back up file
- WordPress.com blog migration to self hosted WordPress website [closed]
- ColdFusion site to WordPress?
- How do I set up a test environment in a sub-folder?
- Site is broken after transferring to adminer
- Changing a domain for a current WP site without having it go inactive
- Pages do not load after migration to new server
- wp-admin keeps forwarding me to an old url