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
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
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