I am glad you asked that. I think for my application, I am going to set up a blank set of tables in the database, and as a new user subscribes, simply move the blank database into their personal directory, that way I can keep all of their data segregated from other users. It may take addition physical disk space, but it would simplify my management dramatically.
Thank you for that question. Mark ----- Original Message ----- From: "Andreas Frøsting" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, March 09, 2002 5:07 PM Subject: RE: databases under users dir > Hi, > > > Anyone know if its possible to have mysql databases under > > $HOME for users. > > I am running RH7.2 and have virtualhosts under apache 1.3.22 > > so i am hoping > > i can put databases under each user account in order to > > control (quota's) > > etc. > > You can put them under each users homedir and symlink to them. > I've used that method a couple of times where I had some pretty large > tables taking up too much space on a particular partition. > > Remember to shut down mysql before moving the databases and remember to > preserve ownership and rights to the files. > > :wq > file://andreas > http://phpwizard.dk (in Danish only) > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php