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]