hello every body,
CREATE TABLE members (
firstname VARCHAR(25) NOT NULL,
lastname VARCHAR(25) NOT NULL,
username VARCHAR(16) NOT NULL,
joined DATE NOT NULL
PARTITION BY RANGE( YEAR(joined) ) (
PARTITION p0 VALUES LESS THAN (1960)
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
May 27, 2009 03:40AM
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.