Re: Using symbolic links for databases and tables

[Paul DuBois]

At 10:34 AM -0700 8/20/99, Scott Hess wrote:
>Paul DuBois <paul@stripped> wrote:
>> What happens when you issue an ALTER TABLE or OPTIMIZE TABLE
>> on the symlinked table?
>
>It gets pulled to the directory the symlink exists in, leaving the original
>tables in the directory the symlink was to.

That's right.  Which is one reason not to symlink tables.

>Our local solution is to symlink all the tables we _don't_ run optimize
>table on, and otherwise be very very careful.

I dunno, that just seems really chancey to me... don't you feel like
you're playing russian roulette? :-)

-- 
Paul DuBois, paul@stripped