How to add a blog into WP MS by queries

The simplest way would be this:

1. Create a subsite called blog2 (TRUST ME!) and use the WordPress built in tools to export from Site1 and import to site2

2. Go to /wp-admin/network/sites.php and click on ‘edit’ for blog2 – change the URL to blog1

3. Use a search/replace plugin to change blog2 to blog1

4. Beer.

Hi Thx, looking foward to test it and just after drinking…
Question before about your post :
Create a subsite called blog2 : blog2 is a subsite of which site ?
Site1 is in my question a multiste
What is Site 2
not very clear, no beer

You said:

I would like to merge Blog1 into Site1 to get this link : https://www.site1/blog1

Your MULTISITE is site1.com

So blog2 would be made on site1.com – site1.com/blog2

Ok Site2 was confused
But could u give me more details about what we have to do :
2/Go to /wp-admin/network/sites.php and click on ‘edit’ for blog2 – change the URL to blog1 ?

Shall I edit the file /wp-admin/network/sites.php ?

This file is indepêndant of blog1 or 2 ? where is the url to change ?

DO NOT EVER EDIT A CORE FILE. EVER.

Anyone who tells you otherwise is shortsighted.

Go to /wp-admin/network/sites.php and click on ‘edit’ for blog2 – change the URL to blog1

That’s what I meant when I said it. Click on it. LOOK at it. What do you see? A field where you can change blog2 ??

If you need this spelled out, then go to YOURDOMAIN.COM/wp-admin/network/sites.php

This is, by the way, the ONLY time I ever recommend changing that. If you do it wrong, it messes up your site badly, so make sure that ‘blog1’ and ‘blog2’ are the exact same number of characters. Don’t go from ‘blog2’ to ‘supercoolblog’ – Instead do ‘supercoolblo1’ to ‘supercoolblog’ (see how the number of characters are the same? VERY important).

OK thx catch it but my initial question was :

How can I add blog1 into Site1 ONLY in using phpmyadmin (by sql queries…)

If I export blog1 or blog2 to get a xml file, modify this name in keeping the same number of character (exp 5 with blogN) and import the Nfile
Could I access to sit1/blogN ?
What changes in these tables : wp_blogs, wp_blog_versions,
wp_registration_log, wp_signups, wp_site, wp_sitemeta …

Thx

Don’t use PHPmyAdmin only to add sites. The reason I didn’t answer that is, as I said, the SIMPLIER way is to use WP as the world intended ??

There’s no reason to. WP can do this for you with the proper functions, and frankly, you don’t sound like you have enough experience with WordPress and Multisite to attempt that one yet.

However if you really are dead set on this, why not experiment so you can see how it works? Take a snapshot of your DB. Then NORMALLY add a site. See what changes.

Heres the biggest warning you’ll need about this: the wp_users table is shared between ALL SITES. So there’s a very high possibility that trying to import the DB, without adjusting everyone’s userID to what they are on the network, will result in the wrong people owning posts, or worse, NO ONE being the author for a post.

Which is why we tell you not to do this ??