InnoDb files in separated directories

[yawyway]

Hi all,
I’ve just realized that I couldn’t use DATA DIRECTORY and INDEX DIRECTORY options of CREATE TABLE command with InnoDB engine.

I use innodb_file_per_table, so it seems I will not be able to put some InnoDB tables on my second RAID stack

Am I right ?

[yawyway]

Hello, nobody to give me hopes ?

[B]yawyway wrote on Thu, 24 June 2010 16:12[/B]

Hi all, I've just realized that I couldn't use DATA DIRECTORY and INDEX DIRECTORY options of CREATE TABLE command with InnoDB engine. I use innodb_file_per_table, so it seems I will not be able to put some InnoDB tables on my second RAID stack Am I right ?

[gmouse]

use symlinks and read http://bugs.mysql.com/bug.php?id=18706

[xaprb]

gmouse is right. These options only work for MyISAM tables, so you have to do something like symlink a database to another device. Symlinking the table files themselves really won’t work. also, if you use ALTER, it also can replace your symlinks with real files, effectively moving your tables back where you don’t want them.