MySQL Forums
Forum List  »  Partitioning

partioning problem
Posted by: asmaa atef
Date: May 27, 2009 03:40AM

hello every body,
CREATE TABLE members (
firstname VARCHAR(25) NOT NULL,
lastname VARCHAR(25) NOT NULL,
username VARCHAR(16) NOT NULL,
email VARCHAR(35),
joined DATE NOT NULL
)
PARTITION BY RANGE( YEAR(joined) ) (
PARTITION p0 VALUES LESS THAN (1960)
data directory='/var/lib/mysql/test'
index directory='/var/lib/mysql/test',
PARTITION p1 VALUES LESS THAN (1970),
PARTITION p4 VALUES LESS THAN MAXVALUE
);
here is the problem,
when i try to change data directory to be other than /var/lib/mysql
say to be /var/test there is an error that appear saying
can not create/write to file /var/test/tb1#p1.myd
although it works when i write /var/lib/mysql
i do not know why?
i tried to change permissions but it still not works
i hope i can find an answer
thanks in advance
asmaa,

Options: ReplyQuote


Subject
Views
Written By
Posted
partioning problem
3429
May 27, 2009 03:40AM
2333
May 28, 2009 07:13PM


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.