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.
how to use multiple databases instead of one
1 reply to this topic
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...
or [php] * 1000... PLEASE READ THE POSTED SOLUTIONS CAREFULLY * 1000000...
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users