MySql Partitioning

Question

I'm trying to create partitions in one big table, but I'm getting this error:

1505 - Partition management on a not partitioned table is not possible

There is any command to convert the table? Or do I have to create a new one and import all data?

There is any problem when using Partitioning with Replication?

Thanks in advance,
Pedro

outis · Accepted Answer · 2009-11-11 16:59:04Z

4

Try:

ALTER TABLE table_name PARTITION BY ...

answered Nov 11, 2009 at 16:59

outis

77.7k23 gold badges155 silver badges228 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Pedro Over a year ago

Well I get sintax error with: ALTER TABLE promo_tool_view PARTITION BY ( partition p001 )

outis Over a year ago

Check the syntax for CREATE TABLE: dev.mysql.com/doc/refman/5.1/en/create-table.html Note that you're missing an argument that specifies what to partition by (hash, key, range, or list).

Pedro Over a year ago

thank it worked with ALTER TABLE promo_tool_view PARTITION BY RANGE (date(view_date)) ( partition p001 VALUES LESS THAN (date('2009-11-01')) , partition p002 VALUES LESS THAN MAXVALUE) ) But now I get his partition function is not allowed, but I think is related with date function.

Collectives™ on Stack Overflow

MySql Partitioning

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related