Why didn’t you use a Network/Multisite install? Problem mainly is that all the queries normally have the current install prefix in use. Without having real access (via $wpdb
) to the prefix, this will get pretty messy. Actually your problem is a X-Y Problem.
It would be less work to export everything from one of the sites, quickly convert the other site to multisite and then import the data again.
Related Posts:
- Multisite posts in categories on network
- find a random blogid across my multisite network that has at least one post published
- WPDB Multiple site’s posts and get featured images
- Creating a Post form outside of the Admin
- Using $wpdb Class to Pull Recent Comments Across a Network
- How to order by blog ID in this multisite ‘List Blogs’ custom function
- Bootstrapping WordPress MultiSite Outsite of WordPress – No $wpdb
- Retrieving multisite blog IDs, somehow failing to foreach them properly
- Network Plugin Creating Pages for Different Subdomains
- Optimizing Query used for a Shortcode
- Use WordPress MultiSite (WPMS) with a remote database for each created site
- How to display users with posts published between two dates (Sorted by Post-Count) [Multisite]
- Check if current site ID and value exist in WPDB
- Multi-site site nav, wpdb->prepare missing argument
- WP MS: How to query over the network
- WP DB Location for “Next Post to Create” Index Value
- WordPress MultiSite Active Directory integration and site privacy
- Password Reset for Users on a Multisite Subsite
- Can a multisite’s blogs be accessible from two different sub-domains?
- How do I change the Multisite URL?
- Can upload doc and pdf but not ppt – not permitted for security reasons
- How Can I Centralize Content Usage and Approval in a WordPress Multi-Site installation
- Allowing periods in usernames
- Single-user registration to access all sites in WordPress MultiSite Network
- Running several WordPress sites on same core / plugins?
- How to use Multiple-Domains in one Multi-Site Installation?
- How to automatically register widgets on new blog?
- .epub file blocked despite ALLOW_UNFILTERED_UPLOADS set to true
- WordPress Multisite Layered Admins
- Changing URL in multisite
- get_sites() for sites registered before given date
- Favicon plugin for WordPress running in network mode (multisite)? [closed]
- WordPress Multisite with VVV
- How to share posts in WordPress Multisite?
- How do I park secure.primary.com on top of the multisite ID:1 domain: www.primary.com (primary multisite domain)
- WordPress multisite,one theme,and different languages?
- Removing /blog/ from multisites cause infinite redirection
- Alias domain to Multi-site installation in Apache
- Multiple WordPress Blogs on one host, using 1 WordPress installation, using multiple templates
- Multisite setup creating custom table
- Woocommerce Multisite Get Orders from Another Site
- Subdomains With WordPress
- Bulk activate a theme on multisite
- Assign role to user on first login, if they are first (after admin)
- Multisite development environment
- Pretty Link Lite Plugin on WP Multisite
- WPMU Development Environment
- turn single domain off
- WordPress Multilingual Theme using Multisite
- WordPress Multisite with different domains and themes
- use get_sites subsite_id with get_bloginfo”() and/or get_custom_logo
- Multiple wordpress installations that shares WordPress & Theme but with separated database
- How can I update dev links for a live site?
- How to recover deleted site in WordPress Multisite?
- Entry page for a wordpress multisite
- WordPress Multisite dashboards redirect to homepage
- WordPress with Tor Onion Service (dual .com & .onion domains for same website)
- Use external database with local multisite
- How to move 1 WP site from a mult-site environment to a different multi-site area
- URL redirect/rewrite rule wordpress multisite
- Issue with wp_get_attachment_url() function for multisite
- Least expensive way to get table prefix in multisite installation
- How to have yearly versions of same site with different content (like yearly conferences)?
- Network Admin URL is shown to anyone before accessing a blog
- Canonical Resource URLs Across a Multisite Network 2012?
- how to migrate wpmu from one host to the other?
- Site’s admin created with wpmu_create_blog accessible only on 2nd attempt
- Getting recent posts from all blogs on mother blog – multisite
- Child Theme Based on Toolbox Not Found
- Network of multisites in WordPress, create new site with all the contents of the main
- Display Different Content For Different Countries?
- Limit blogs creation
- How To Disable Add new users On Subsites In Multisite?
- MultiSite: new Sites not showing up
- What is the best method of installing WP on multiple add-on domains?
- How to delete user from MU site when the user is removed from their site?
- more tables created when create a new site
- Installing wordpress on a subfolder of adsense approved domain
- Launch Media Library for specific MU site
- WP-CLI Error Requesting CURL Extension
- Allowing users to manually add or remove themselves to/from WordPress multisite blogs
- multiple domains point to same site on WP-MU
- Error establishing a database connection after moving local wordpressmultisite from one directory to another
- Can I replace the “Upgrade Network” with SQL query?
- How to convert multisite subdomain from http to https
- One membership area for two websites
- Multisite domain mapping with SSL redirects to main domain
- Define a new sub-folder naming – Multisite
- Multisite install in a subfolder won’t work with www
- Backend freezing on certain pages of a subsite
- Modifying get_author_posts_url() in Multisite
- Domain mapping breaks some plugin scripts and css
- Multisite – User creation for second site from first site?
- Whats a good strategy for localising WordPress post and page content?
- Get users from all/specific blog by user_role and current_user role
- Updating themes customized by users
- Pages redirect me to the homepage
- Cannot login to admin panel in multisite install if subdomain is added to hosts file
- Using a number for limiting registering or banning on multisite
- Help with image directory issues on wordpress multisite