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

Answer 1

Try:

ALTER TABLE table_name PARTITION BY ...