I will admit to being a newbie to mysql and the like. I have recently switched to dreamhost and am at the beginning of a steep learning curve and would like to have your help to avoid any mistakes at the beginning.
My website plan is the following.
Have a root domain. root.com that is only accessible to me - that part is easy.
Have a phpbb for the root.com site.
Create multiple subdomains of root.com with individual private wiki's and seperate user groups. Ie. users with permissions to edit a.root.com will not have rights to edit b.root.com.
My initial need is for ~16 subdomains (a - p) with possible expansion to an even larger number later.
What is the directory structure I should use for this?
Do I use a common MySQL database with seperate hostnames for each subdomain or shoudl I have a seperate database AND hostname for each subdomain. Also, do I install Mediawiki (or another wiki) under each subdomain (a.root.com, b.root.com) or do they all go in root.com\wiki or root.com\wa, root.com\wb ect?
I have been unable to determine which directory structure will cause the least problems for future growth and management. I don't want to do something now that will cause me grief later.