Adding a second Blog - need a second MySql databse

Developer help
1

I followed this tutorial to add a second blog to my server - and the nginx and ghost are working fine - but all the posts are shared.

I figured out that the (outdated) tutorial didn’t create a second MySql database for the second blog.

I am pretty comfortable with MySql and wondered is there is a sql script to create a the databse tables for the second blog?

Ubuntu
Ghost-CLI version: 1.13.1
Ghost version: 3.13.3 (at /var/www/redrungroup.com/ghost)

config.production.json for blog1
“database”: {
“client”: “mysql”,
“connection”: {
“host”: “localhost”,
“user”: “ghost”,
“password”: —",
“database”: “ghost_production”
}
},

config.production.json for blog2
“database”: {
“client”: “mysql”,
“connection”: {
“host”: “localhost”,
“user”: “ghost”,
“password”: —",
“database”: “ghost_production” <== should be something like ghost_production_blog2
}
}

thanks for any help.

-Peter
2

Solved my own issue.
The answer involves mysqldump.

3

I could do with solving this.

When trying to install a second instance, I am getting a mysql error (and I am out of my depth).

Would you consider sharing how you managed it (whole process)?

4

Well, to be clear, I was not getting any MySQL errors. It was just that both my first and second blog were using the same MySQL instance, so posts from each site were showing up on both blogs.

So I wouldn’t expect my solution to help you.

But if you post details about the steps you used to set up your site, and the specific MySQL error(s) you are seeing, maybe I or someone else could try to help.

thanks

-Peter