That would be the best way - just give them different names. the alternative would be to change the prefix of the tables/entries - but that can get confusing and if you are not looking at a massive install I do not see the advantage.
just create joomlaDB1, joomlaDB2, etc with separate users with only the needed rights for each db... --Michael T. Bendorf-- Technology Administrator A-C Central C.U.S.D. #262 217.476.3312 ext. 2019 DID #: 217.476.6019 Cellular: 217.306.6824 "I'm trying to teach myself to ask the same questions that you do during your lectures so that I do not need you any more." A good teacher is like a candle - it consumes itself to light the way for others. "The computer revolution hasn't started yet. Don't be misled by the enormous flow of money into bad defacto standards for unsophisticated buyers using poor adaptations of incomplete ideas." - Alan Kay On Tue, Sep 28, 2010 at 3:06 PM, Paul Peacock <ppeac...@lexington.k12.il.us>wrote: > so here's a basic question: > > if I want to have mySQL manage multiple joomla sites on the same server, do > I need to setup multiple databases. If so, what is the best way to manage > that. > > On Tue, Sep 28, 2010 at 12:11 PM, McKay, Curtis <cmc...@bths201.org>wrote: > >> This list… ;-) >> >> >> >> Anyway, couple comments: >> >> Unless you have zero experience with linux I’d probably recommend using a >> linux distro for your Joomla box since most websites, this list, and others >> offering help use linux and therefore you might be able to get better help >> if your setup matches to majority of installs. >> >> >> >> For Joomla you’ll need php installed, since you’ll have php and mysql, >> installing phpmyadmin to do your mysql management is pretty much a no >> brainer. >> >> >> >> Curtis McKay >> >> Network Administrator >> >> Belleville Township High School District 201 >> >> cmc...@bths201.org >> >> >> >> *From:* tech-geeks-boun...@tech-geeks.org [mailto: >> tech-geeks-boun...@tech-geeks.org] *On Behalf Of *Paul Peacock >> *Sent:* Tuesday, September 28, 2010 12:05 PM >> *To:* Tech-Geeks Mailing List >> *Subject:* [tech-geeks] mysql help >> >> >> >> I am getting started working with mySQL for a new installation of Joomla >> in a Windows server. What are my best resources for help? >> >> >> >> Thanks. >> >> >> >> Paul Peacock >> >> Lexington High School >> >> | Subscription info at http://www.tech-geeks.org | >> > > > | Subscription info at http://www.tech-geeks.org | >
| Subscription info at http://www.tech-geeks.org |
