Search code examples
mysqlpartitioningdatabase-partitioning

MySql Partitioning

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

Solution

  • Try:

    ALTER TABLE table_name PARTITION BY ...