At 8:47 PM -0400 7/15/99, Andy Frankford wrote:
>Hello Paul,
>
>I've been wondering about 'dispersing' DBs too - putting the DBs somewhere
>in my customer's WEB directory structure, mostly for dasd space management.
>I wouldn't care about accessing the files outside of the mySQL engine
>environment, e.g permissions can be whatever mySQL needs. That would also
>be handy when we do a site or customer backup.
>
>Your response re. using sym-links suggests this would work fine. True?
That's correct. Don't use symlinks for tables, though. ALTER TABLE and
OPTIMIZE TABLE will surprise you.
>
>Thanks!
>
>Andy
>Alliancecommerce.net
>
>
>
>
>-----Original Message-----
>From: Paul DuBois [mailto:paul@stripped]
>Sent: Thursday, July 15, 1999 5:11 PM
>To: Anna Winkler; MYSQL List
>Subject: Re: Can databases be stored in multiple directories?
>
>
>At 1:58 PM -0600 7/15/99, Anna Winkler wrote:
>>Hi,
>>
>>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
>
>---------------------------------------------------------------------
>Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
>posting. To request this thread, e-mail mysql-thread7475@stripped
>
>To unsubscribe, send a message to the address shown in the
>List-Unsubscribe header of this message. If you cannot see it,
>e-mail mysql-unsubscribe@stripped instead.
>
>
>
>---------------------------------------------------------------------
>Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
>posting. To request this thread, e-mail mysql-thread7496@stripped
>
>To unsubscribe, send a message to the address shown in the
>List-Unsubscribe header of this message. If you cannot see it,
>e-mail mysql-unsubscribe@stripped instead.
--
Paul DuBois, paul@stripped
