Re: This partition function is not allowed

2012-01-27 Thread Johan De Meersman 
- Original Message -
> From: "Adarsh Sharma" 
> 
> Is it possible I upgrade to higher version 5.5 with existing data

Yes, look for the upgrade notes in the online documentation.

-- 
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel

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

This partition function is not allowed

2012-01-26 Thread Adarsh Sharma 

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