List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:July 18 1999 4:40pm
Subject:Followup on symlinking database directories
View as plain text  
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
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