sorry to cross post. Actually I also want to achive the same thing for virtual hosting. Would you tell me how you will create a database in $home/mysql ? What I know is when you say create database , it creates under $mysqlhome/var/
Please calrify the doubts. Praful ----- Original Message ----- From: "Support" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, March 10, 2002 04:40 Subject: Re: databases under users dir > Hi > > Thanks for the tip! it works fine. > > Now all i need to do is modify my create database code to use $HOME/mysql > and make symbolic link > > Mark > -- > Obantec Support > www.obantec.net > WebHosting and Domains > Nominet UK Tag Holder > ----- Original Message ----- > From: "Andreas Frøsting" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Saturday, March 09, 2002 10: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 > > //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 _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com --------------------------------------------------------------------- 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