Thanks, that worked. However, it appears that each time I execute an alter table command (such as addng a new index), I'll have to repeat the process of creating the index, moving the file, then again defining the symlink.
MySQL does not seem to respect the link with new DDL commands like that. Not the end of the world, just a bit of a surprise behavior to me. Again, thanks. On Saturday 20 October 2001 06:37 pm, you wrote: > On Sat, Oct 20, 2001 at 05:54:28PM -0400, tony.icuc wrote: > > Would anyone know of a method to create/fake/move/configure and > > index on an alternate disk than the base table? I hail from a > > platform that allows specific disk specification for partition, > > index and alternate key files. > > > > Naturally, I referenced Paul DuBois' amazing book, to no avail. > > Just curious if this is possible with the standard MySQL 3.23.26. > > Create the index, move the .MYI file to where you'd like, and leave a > symlink which points to it. MySQL will respect that. > > Jeremy --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
