Database Structure Question

[blackrock]

I've got a lot of blogs I'm managing and my database has the ability to support multiple blogs by using a sub folder.

Does anyone who's experienced at managing databases have advice on the best structure.

-Unique Database for each site?
-Multiple sites in one database?

 

[L146705]

Unique Database for each site is the one I would go for because it makes the sites more transferable and easier to sell etc... also with shared dbs if one site gets hacked they all do or if one site goes down they all do as its on a shared db.

 

[blackrock]

Unfortunately because I was ignorant before I started many of my sites are already grouped. Is it possible to separate them and make them there own unique database?

 

[Stanley]

how big are the databases?

 

[nickycakes]

For spammy auto blog type stuff use 1 database for all of them.

 

[blackrock]

They aren't huge. I'm not doing spammy blogs. These are sites with decent keyword domains that I want to build in to authoritative sites.

So eventually each one will have 200-500 posts.

 

[Stanley]

Don't bother splitting them into separate databases unless you plan to host the sites on different servers. If the database gets too big you can just get a dedicated mysql server.

 

[blackrock]

Is it easy to transfer the files for one site to another database? I think I found a copy function that would send it to another database or I could export it.

I haven't done it cause I didn't want to screw it up. Is it easy?

 

[drugoon]

It should be pretty easy, but if you never did this before try making some tests first to see how it goes and then go to your live domains/databases.

Good luck.

 

[blackrock]

Thanks everyone.