In the last episode (Jul 21), LaCraze said:
> I am a Redhat user. Presently using RH 7.3 and mysql 3.23. I am doing
> some web hosting services. I have system quota installled and enable.
> Is there a way, to tell mysql to have individual databases in my
> user's directories instead of /var/lib/mysql/ ?
>
> For example user1 has a web space in /home/hostings/user1 and his
> database in /home/hostings/user1/data and user2 will have his web
> space in /home/hostings/user2 and database in
> /home/hostings/user2/data
Create symlinks from the mysql data dir to each user's directory:
/var/db/mysql/user1 -> /home/hostings/user1/data
/var/db/mysql/user2 -> /home/hostings/user2/data
etc. Then any table the user creates in their database will end up in
their data dir.
--
Dan Nelson
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
