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
