sallam Posted September 28, 2005 Share Posted September 28, 2005 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. Quote Link to comment https://forums.phpfreaks.com/topic/2579-how-to-use-multiple-databases-instead-of-one/ Share on other sites More sharing options...
ryanlwh Posted September 29, 2005 Share Posted September 29, 2005 (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. Quote Link to comment https://forums.phpfreaks.com/topic/2579-how-to-use-multiple-databases-instead-of-one/#findComment-8574 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.