Skip navigation links

MySQL Forums :: Table Space :: MySQL equivalent of tablespace?


Advanced Search

Re: MySQL equivalent of tablespace?
Posted by: styphinson toms ()
Date: March 18, 2008 04:26AM

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

Options: Reply•Quote


Subject Views Written By Posted
MySQL equivalent of tablespace? 32688 Kreshna Aryaguna 12/19/2006 04:24AM
Re: MySQL equivalent of tablespace? 15146 marc castrovinci 12/19/2006 06:54AM
Re: MySQL equivalent of tablespace? 11318 Kreshna Aryaguna 12/19/2006 08:49PM
Re: MySQL equivalent of tablespace? 8679 Thomas CORBIERE 02/14/2007 02:49PM
5.0 does have per-table tablespace 9346 Brian Papantonio 07/09/2007 09:23AM
Re: MySQL equivalent of tablespace? 6749 styphinson toms 03/18/2008 04:26AM
Re: MySQL equivalent of tablespace? 5305 Rana Prathap 12/16/2008 03:57AM


Sorry, you can't reply to this topic. It has been closed.
powered by phorum

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.