At 1:58 PM -0600 7/15/99, Anna Winkler wrote:
>I'm a new user to MySQL and databases in general. I'd like to know if the
>grant tables exist in /usr/local/mysql/var and other databases exist in
>another, user-defined directory? Currently all of my databases are in
>/usr/local/mysql/var, but I'd like to create databases that exist in
>different directories (like ~myhome/new_dbase_dir).
You can put a database directory wherever you want.
If it's not under the MySQL data directory, though,
you need to put a symlink to the real location in
the data directory.
Also, remember that everything in your database directory needs to
be read/write to user that the server runs as. If your reason
for asking the question was that you want to make database files
private to yourself, you can't do it. (Well, you *could* do it,
if the server runs as root, but that's a bad idea.)
Paul DuBois, paul@stripped