If you're going to be using MySQL, I would recommend installing apache and php, then installing something called phpMyadmin. Web-based util to do anything with MySQL.
Thank god you're not MSSQL. MSSQL is built to handle massive amounts of data. This isn't an option, whether you have the budget or not. At my work, our Database server is running MSSQL 2000 Enterprise, has 18 databases on it ranging from 6 to 20 gigs in size. I think this would be a bit of overkill for less than 50 people.
You might try looking at Sourceforge.net to see if someone has anything similar to this. It would be free to use, and might give you some direction to go.
Also, if you use apache, mysql, phpmyadmin option, the easiest distros to use it with I believe are debian and gentoo. Their package management systems allow you just to tell is to install and the distros set it all up for you.
__________________
"You hear the one about the fella who died, went to the pearly gates? St. Peter let him in. Sees a guy in a suit making a closing argument. Says, "Who's that?" St. Peter says, "Oh, that's God. Thinks he's Denny Crane."
Last edited by bendsley; 08-09-2005 at 05:17 AM..
|