Maxim,
I posted a very similar question yesterday and got a very helpful reply.
Please see it below:
Databases are essentially just directories. What you do is create a
directory in the users home directory. Then, do this:
ln -s /path/to/home/dbdir /path/to/mysql/data/dir/somedbname
Then grant the user access to that db. Your all set :)
----- Original Message -----
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 21, 2001 4:06 PM
Subject: create db in separate directory
> I'm working on a web-hosting site where we'll be giving users a MySQL
> database. We wanted to store the database in the user's own directory,
> where we'll be enforcing size quotas. So far though, I haven't been able
to
> find a way to create a database in a directory other than MySQL/data.
I've
> seen a couple of references to symbolic links but am not sure if this is
the
> answer.
---------------------------------------------------------------------
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