MySQL Forums
Forum List  »  Partitioning

partitioning question?
Posted by: asmaa atef
Date: December 14, 2009 08:34AM

hello everybody,
when i try to make a partitioning for a table as following

create table parti(i int) engine=innodb partition by list(i)( partition p0 values in(1,2,3,4,5) data directory='/home/finserv2/Desktop/asmaa' index directory='/home/finserv2/Desktop/asmaa',partition p1 values in (7,8,9) data directory='/home/finserv2/Desktop/asmaa' index directory='/home/finserv2/Desktop/asmaa');

it gives me Query OK, 0 rows affected (0.01 sec)
this means that the query is done but when i check the folder /home/finserv2/Desktop/asmaa i find nothing and no files there neither for index nor data.

i donot know what is the problem and where is partition files?????
thanks in advance,
asmaa

Options: ReplyQuote


Subject
Views
Written By
Posted
partitioning question?
3747
December 14, 2009 08:34AM
2292
December 16, 2009 12:33AM
2147
December 16, 2009 07:44AM
2286
December 16, 2009 11:53PM
2181
December 17, 2009 02:39AM
2166
December 18, 2009 12:40AM
2233
December 22, 2009 02:50AM


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.