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

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.