Re: Symlink InnoDB tables without stopping MySQL

2008-04-24 Thread Dobromir Velev
Hi, I guessed it was something like it and that is why I wanted to make sure how it should be done. Using the ALTER TABLE table DISCARD TABLESPACE doesn't seem to work as expected - I succeeded to crash the test server twice. See the mysql log details below. What I did was the following: -

RE: Symlink InnoDB tables without stopping MySQL

2008-04-23 Thread Jerry Schwartz
If Linux works the same way as HP-UX (and it should), anything you do to an open file (including deleting it) has no effect until the file is closed. The MySQL server is still using the old file. The next time it stops and restarts, it will follow the symlink. I don't know what the effect of