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?
- Multisite: differences between subdomain and subdirectory mode? Can it be switch after installation?
- Create rewriterules for different domains in htaccess file with WP multisite
- Moving local wordpress page to a real server subdomain broke my permalinks?
- Point static content like css and js to cookieless subdomain
- Nginx Wildcard SSL with WordPress Multisite Subdomains
- Multisite – Parent site with Polylang with different domains for each language [closed]
- A WordPress site with more than one domain name / Parked domains
- Https and Http Login Issue on WordPress Multisite
- Mirror Website Content Across Multiple Subdomains
- WordPress Multisite loads wrong subdomain dashboard
- How to map domains to specific pages in WordPress and display them in the address bar?
- Login issues on WordPress Multisite and domain mapping
- Multisite htaccess with domain rewrites
- Specific plugin script not working on subdomain
- How to implement this subdirectory mapping in multisite?
- WordPress MU with subdomain
- Not being allowed to use some terms in Add New Site in WordPress