Re: Tablespace in MySQL

[styphinson toms]

when I am trying to create table space am getting like this
mysql> CREATE TABLESPACE simfonespace
-> ADD DATAFILE 'simfdata'
-> ENGINE = innodb;
Query OK, 0 rows affected, 1 warning (0.00 sec)

i dont know whether the tablespace is created if so how to use it can any one help

My requirement is same as youvrajsinh's

I need to put the tables in a tablespace created in my windows D: drive and all the index in another tablespace created in windos E: drive

How can i achieve this please help me
thanks in advance