Rather than manually making changes to the WP tables, I use the “WP Clone” plugin. It saves the entire blog to a zip file, then you Restore that on the new site (using WP Clone). The restore process makes any needed changes to the domain names/links/whatever, so the new site just works.
You will log in to the new site with your old site’s credentials, but all users, media, posts, themes, plugins, etc will work just fine on the new site.
You’ll find the plugin here https://wordpress.org/plugins/wp-clone-by-wp-academy/ . I’ve used it several times, and it Just Works.
(Note, no affiliation with the WP Clone guys other than a satisfied user.)
Related Posts:
- Serve HTTPS requests from subdomain
- How can i run the same WordPress install on multiple subdomains?
- 2 WordPress install with same database
- Subdirectory mapping for a WordPress website
- Can I use WP’s built in domain mapping with WP installed on a sub-domain?
- Serve HTTPS requests from subdomain
- Can a multisite’s blogs be accessible from two different sub-domains?
- WP Multisite development with Mamp Pro and wildcard subdomains, not really working for me
- Hosting a WordPress blog as a sub folder from a S3 website
- How to use alias domain for multisite installation?
- Share WordPress Login Cookies Between Two Subdomain Installs
- “Preview Changes” button doesn’t show changes for previously published posts/pages
- Load template for specific subdomain
- Using subdomain m.website.com for mobile theme?
- Changing Multisite URL after the subsite has been in use
- How do I use different domain for subdomains in WP Multisite?
- Possible to create a multisite network where the main site is non-WP?
- Changing admin sub-domain in WordPress multisite
- Classic Conundrum: How do I map a Sub-Domain in WordPress? [closed]
- How to Redirect login User with Mapped Domiain Primary blog Url to Original Sub-site Url
- WP MU – Accessing ‘Domain-Mapped’ WP-Admin with a subdomain
- General Settings for WordPress Subdomain
- Moving a blog from a subdomain to a folder
- WP Multisite – domain mapping to domain.com and separate site to domain.com/help
- Child Site doesn’t appear in the Network menu
- How to retrieve TLD domain for the current website?
- How to serve assets files (js, css, images) on a subdomain
- Migrating wordpress multisite and domain mapping plugin
- Moving WP installation form subdomain
- Will WordPress installed on a whole domain interfere with other files in a subdomain or subfolder?
- Network of subdomains [closed]
- Moving website from expired domain to an active subdomain
- Change the subdomain?
- Login problems on multisite installation with different domains
- Two domain for one site not working in mobile
- Installed WordPress Location
- MU/Subdomains + Domain Mapping + SSL?
- WordPress subdomain mapping/”archiving” [duplicate]
- WordPress MU subdomain vhost
- WordPress CDN Subdomain URL not accessible to the public
- Install multisite wordpress on a subdomain and map to top level domains
- How can I redirect some pages to new subdomain? [closed]
- How do I (re)design my corporate website in WordPress without downtime?
- change wordpress upload url to subdomain on xampp local
- Multisite on single wordpress
- Can I have a WordPress site stored on a subdomain of another website owned by me?
- WordPress Multisite with subdomains on different domains
- Theme switch when accessed from sub domain
- Folder wordpress page redirect
- Subdomains permalinks issues
- Relative Root Url For Sub domain name
- wordpress sub-directory sites on a sub-domain?
- Subdomains pointing to a permalink URL
- How to make each category a subsite?
- WordPress Multisite and how to apply sef urls only to specific sites
- How to Set up a Wildcard Subdomain for all WordPress Posts?
- multisite installed on subdomain now want another subsite on subdirectory
- WordPress cloned but frontend still displays http://old_wordpress_site
- How to load subdirectory mobile theme and redirect mobile devices to subfolder?
- WordPress deleting subdomain from the URL
- How can I change block editors suggested links to display another url (i.e. from api.mysite to www.mysite)
- WordPress Multisite with Wildcard Certificates not mapping correctly
- How can I move the subdomain to the root domain?
- Can I edit domain settings if I didn’t create the site?
- Issue while installing wordpress in subdirectory due to SSL [closed]
- Multisite has SSL certificate, but media library is still http://
- Add subdomain for Vue.js application
- new WPMS site not working / Q setting up new site/subdomain
- Question of the subdomain
- Create a new hyperlink to wordpress blog
- Subdirectory and domain multisite installation
- Multisite: Run a subdomain install from a directory install
- Single WordPress Installation with Sub domains
- Why is my subdomain returning a 403 status?
- Some Subdomains on a Multisite Install Not Found
- Is it possible to put a site other than #1 as a Multisite top-level domain?
- WordPress site with subdomain without multisite installation
- I have a question about the name of my blog [closed]
- Generated URLs don’t reflect accurate URLs.
- Cookies in Multisite network where sites have their own domain name?
- Hide sub domain created for local CDN
- Change author URL from /author/xyz to a subdomain xyz.domain.com for each new registered users
- Development to production, how to move a development site from http + dev.example.com to a production site https + example.com?
- I’ve mistakenly installed another wordpress in my main domain instead of subdomain
- Migrating WordPress site from subdomain to subdirectory
- How to migrate Subdomains to new hosting?
- How to use WordPress Multisite With Different Domain Names?
- Host the wp-admin on another domain?
- Multisite on Windows with wildcard subdomains
- How to share cookies and sessions between domain and subdomain?
- Prevent “main” WPMU site_url() being returned in functions
- Are nested subdomains possible with a subdomain multisite?
- Mapping Domains to Permalinks (not multisite)
- Anyone figured out how to use WordPress MultiSite with Domain Mapping & SSL?
- Domain mapping (without plugin) in 4.5.x multisite?
- Multisite Domain Mapping with SSL
- How to set up wordpress domain mapping on MAMP Pro
- WordPress Multisite with multiple domains using Nginx
- Steps for Moving Multiple WordPress Installs to a Multisite Install?
- Blog posts on one subdomain, pages on another