Hi, Thanks for pointing it out - I just found the following commands. ALTER TABLE tbl_name DISCARD TABLESPACE; ALTER TABLE tbl_name IMPORT TABLESPACE;
I will test it and let you know if it works Thanks Dobromir Velev On Wednesday 23 April 2008 16:27, Sebastian Mendel wrote: > Dobromir Velev schrieb: > > Hi, > > What I'm trying to do is to create a new InnoDB table on a different disk > > and symlink it to an existing database. > > I have innodb_file_per_table turned on and here is how I tried to do it > > > > > > mysql> \u test > > mysql> create table test (...) ENGINE = 'InnoDB'; > > mysql>\q > > > > move the test.ibd file to the other disk > > create a simlink in the database directory > > flush tables; > > > > > > This works as expected but there is something that bothers me - I > > inserted about 60K rows in the new table and all queries I tried are > > working including selects, inserts and updates. The "SHOW TABLE STATUS" > > command displays relevant results and still the test.ibd file to which > > the symlink points hasn't been changed or accessed at all. > > > > Any ideas are welcome > > you need to setup per-table tablespace, did you? > > Section 13.2.3.1, “Using Per-Table Tablespaces”. > > http://dev.mysql.com/doc/refman/5.0/en/innodb-init.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]