Jump to content

Archived

This topic is now archived and is closed to further replies.

sallam

how to use multiple databases instead of one

Recommended Posts

my host requires that the max database size is within 200MB, although unlimi

ted databases are allowed.

My IPB forum database is growing fast, and one single table (posts) is over

300MB now, my host is kind, but one day they will sure contact me about it.

 

Is there any way that I can somehow move the posts table to a separate datab

ase, or even better, split the post table into several databases?

 

I'm new to mySQL, so please give me detailed instructions.

many thanks.

Share this post


Link to post
Share on other sites

(SELECT *, 1 AS db FROM db1.posts)
UNION
(SELECT *, 2 AS db FROM db2.posts)
ORDER BY datetime DESC

 

Your results would be populated with posts from the two databases ordered by post time. You would also have an extra column db to check for which db it's coming from, so you won't mess up the ids.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.