List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:August 20 1999 7:03pm
Subject:Re: Using symbolic links for databases and tables
View as plain text  
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
Thread
Using symbolic links for databases and tablesMarek Chlup19 Aug
  • Using symbolic links for databases and tablesJani Tolonen20 Aug
    • Re: Using symbolic links for databases and tablesPaul DuBois20 Aug
  • Re: Using symbolic links for databases and tablesMarek Chlup20 Aug
  • Re: Using symbolic links for databases and tablesScott Hess20 Aug
    • Re: Using symbolic links for databases and tablesPaul DuBois20 Aug
      • Re: Using symbolic links for databases and tablescshepard20 Aug
      • Re: Using symbolic links for databases and tablesMichael Widenius23 Aug
  • Re: Using symbolic links for databases and tablesScott Hess20 Aug