List:General Discussion« Previous MessageNext Message »
From:<sinisa Date:July 19 1999 1:27pm
Subject:Followup on symlinking database directories
View as plain text  
Paul DuBois writes:
 > This is a followup on the recent discussion about moving a database
 > directory out of the data directory and then putting a symlink to
 > the new location in the data directory.
 > 
 > There *is* one problem with this that I forgot about.  There is
 > no problem using the database, but in pre-3.23 versions of MySQL,
 > if you execute DROP DATABASE, MySQL will remove all the files in the
 > database, then give an error when it tries to remove the database
 > directory.  This fails because the "directory" is really a symlink.
 > You must fix things up manually yourself.
 > 
 > This problem is fixed in MySQL 3.23.
 > 
 > Fix for pre-3.23 MySQL: don't drop the database. :-)
 > 
 > --
 > Paul DuBois, paul@stripped
 > 

Paul my friend,


Who said to use symlinks. Use links ....


Sinisa

+----------------------------------------------------------------------+
| TcX  ____  __     _____   _____  ___     ==  mysql@stripped            |
|     /*/\*\/\*\   /*/ \*\ /*/ \*\ |*|     Sinisa Milivojevic          |
|    /*/ /*/ /*/   \*\_   |*|   |*||*|     mailto:sinisa@stripped|
|   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*|     Larnaka, Cyprus             |
|  /*/     /*/  /*/\*\_/*/ \*\_/*/ |*|____                             |
|  ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^                            |
|             /*/             \*\                Developers Team       |
+----------------------------------------------------------------------+
Thread
Followup on symlinking database directoriesPaul DuBois18 Jul
  • Followup on symlinking database directoriessinisa19 Jul
    • Re: Followup on symlinking database directoriesPaul DuBois19 Jul
      • Re: Followup on symlinking database directoriessinisa19 Jul
        • Re: Followup on symlinking database directoriesPaul DuBois19 Jul
          • Re: Followup on symlinking database directoriessinisa19 Jul
            • Re: Followup on symlinking database directoriesPaul DuBois19 Jul
              • Re: Followup on symlinking database directoriessinisa20 Jul
            • Re: Followup on symlinking database directoriesMichael Hase19 Jul
              • Saving & Loading Images...Nolberto Rojas Gil19 Jul
                • Saving & Loading Images...sinisa20 Jul