[cobalt-users] Binding MySQL DBs to users

["Carrie Bartkowiak" <ravencarrie@xxxxxxxx>]

Howdy!
By golly, I think I have a question that hasn't been solved in the
archives - yet.  ;)
And yes, I *did* search for it, and found a similar problem from a post a
year ago but no clear solution.

Since Cobalt's pkg dumps all of the MySQL databases in one spot - is there
any way that we can bind a user's database to his space? So that if his DB
is limited by the space that he has on the server. (For example, if his
space limit is 50 megs, then all of his site files and all of his mysql data
had better be under 50 megs.)

Doing a search on Google for this gave me a one post on a mailing list where
a man suggested to create a script that would check each user's DB size each
night (drop it in cron) and email them if it started getting close to a
certain amount so they'd know to dump it.
I *could* do this, if I knew how to measure the DB size. (That's off-topic
but if anyone knows how to do it I'd sure appreciate sharing the
knowledge...mysql_fetch_lengths just ain't cutting it for me so far...)

Another suggestion is to run a separate mysql daemon for each user with a
DB, which I'm not willing to do. Especially since the 'optimum' way to run
these daemons would be to put each one on a separate port.

I've seen plenty of hosts out there who say that "your mysql database will
be limited to 10MB", etc. etc. so someone's found a way to do it. But I
can't find a php or cgi script anywhere that will let me in on the secret.

Anyone know the secret - or at least a piece of the puzzle?

CarrieB