Jump to content


Photo

how to use multiple databases instead of one


  • Please log in to reply
1 reply to this topic

#1 sallam

sallam
  • New Members
  • Pip
  • Newbie
  • 1 posts

Posted 28 September 2005 - 08:32 PM

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.

#2 ryanlwh

ryanlwh
  • Staff Alumni
  • Advanced Member
  • 511 posts

Posted 29 September 2005 - 07:18 PM

(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.
Please use EDIT * 100...
Please use
or [php] * 1000...

PLEASE READ THE POSTED SOLUTIONS CAREFULLY * 1000000...




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users