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 -----
From: "Andre Guerrero" <[EMAIL PROTECTED]>
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.
>
> Can anyone provide me an answer/way to create a database in a different
> directory? Any examples would be greatly appreciated. So far I'm using a
> PERL script to create the database - if anyone knows how to incorporate
> creating this database into the following script that would be very cool.
>
> Thanks, André
>
>
>
> use DBI;
>
> $database = "AndreTest2";
> $host = "dvdba";
> $user = "root";
> $password = "";
>
> $dbh = DBI->connect("dbi:mysql:dataverse", "root", "");
> $rc = $dbh->func('createdb', $database, $host, $user, $password, 'admin');
>
> $dbh->disconnect;
>
>
>
----------------------------------------------------------------------------
----
> ---------------------------------------------------------------------
> 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