MySQL Forums
Forum List  »  InnoDB

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


Subject
Views
Written By
Posted
34775
December 19, 2006 04:24AM
15768
December 19, 2006 06:54AM
11981
December 19, 2006 08:49PM
9201
February 14, 2007 02:49PM
Re: MySQL equivalent of tablespace?
7260
March 18, 2008 04:26AM
5776
December 16, 2008 03:57AM


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

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.