2 Blogs on 1 MSQL Database?

That’s no problem at all.
All you need to alter is the ‘table_prefix’ in wp-config.php when you install the second blog.
The first blog will have a prefix of ‘wp_’ so just make the second have a prefix of ‘wp2_’ and all will be good ??

So by making the prefix of the second blog ‘wp2_’ the second blog will be able to read all of the entries and comments from the first?
Also if this is the way to do what I am trying to do… where do I change the prefix?
Many Thanks

The two blogs will be entirely seperate – did you need them to share data ?
Open wp-config.php – the option to alter the table_prefix is in there.

Sharing data would be handy as this way I’d be able to see what the blog will ‘look’ like etc. I won’t be adding any posts or comments in the 2nd test blog just change the design , templates and plugins etc.

If you’re testing templates, may I suggest just renaming the different index.php and wp-layout.css files you’re testing?
Example: Your current known-good layout uses index.php/wp-layout.css
You’re tweaking another layout with index2.php/wp-layout2.css
In index2.php, you’d make sure you’re calling for wp-layout2.css (rather than the default wp-layout.css).
That way, you get the best of both worlds and you don’t need to undertake two WP installs – even though it is small. ??

Great Idea!
Thank you very very much. I’ll do that.
Many Thanks again, you’re all great help!

Nice, glad we were able to help. You will link to your blog in your member profile, so we can see how you’re doing…riiiight? ??

Hi Podz, I guess I could use the same trick to migrate from one domain name to another, both under same hosting/server?

Let’s say, I have blog1 going fine, then install a new blog2, change wp-config.php such that blog2 with new domain name connects to the same database of blog1. Later delete installation blog1 under old domain name.

Alright doing that?

sfong15 – you cannot have two active blogs sharing the same database. Because they cannot share precisely the same name / url, things will certainly break.

But….. if there is no sharing like that, it should be okay.. (I’ve not yet had a coffee though so do post again if what I’ve said doesn’t help.)

https://rephrase.net/box/word/multiply/

two+ active blogs and the same database

I am currently using 95 with this setup and no breakage.

https://codex.www.ads-software.com/Installing_Multiple_Blogs

Yes, Podz, it broke my test blog because wp-blog-header couldn’t resolve 2 different url.

Any better way to do migration from one domain name to another under same hosting?