Dear all,

Today i am creating a partition table in my mysql server
5.1.34-community-log .

create table sample( a integer, dt_stamp timestamp not null default
current timestamp, content varchar)engine= innodb
PARTITION BY RANGE ( UNIX_TIMESTAMP(dt_stamp) ) (
-> PARTITION p0 VALUES LESS THAN ( UNIX_TIMESTAMP('2012-02-01
00:00:00') ),
-> PARTITION p1 VALUES LESS THAN ( UNIX_TIMESTAMP('2012-03-01
00:00:00') ),
-> PARTITION p8 VALUES LESS THAN ( UNIX_TIMESTAMP('2012-10-01
00:00:00') ),
-> PARTITION p9 VALUES LESS THAN ( UNIX_TIMESTAMP('2012-11-01
00:00:00') ),
-> PARTITION p10 VALUES LESS THAN ( UNIX_TIMESTAMP('2012-12-01
00:00:00') ),
-> PARTITION p11 VALUES LESS THAN (MAXVALUE)
-> );
ERROR 1564 (HY000): This partition function is not allowed

After some Rn D on the error I found my mysql version does not support
partitioning on timestamp column.
So i need to upgrade mysql server.
But my my.cnf requirements are :-
innodb_data_file_path |
/hdd2-1/innodb_data1/ibdata1:250G;/hdd3-1/innodb_data2/ibdata2:250G;/hdd4-1/innodb_data3/ibdata3:1G:autoextend

It takes near about 5 -6 hours to create these files & start my server.
Is it possible I upgrade to higher version 5.5 with existing data dirs
and existing innodb tables.
Is there any link that shows how to upgrade mysql in
[root@s6-mysd-1 ~]# cat /etc/issue
Caos NSA: Node - Server - Appliance (release 1.0/Cato) \

Thanks in advance.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql