Partitioning table with pt-online-schema-change

MySQL & MariaDB
1

Hello guys,
Is it a seamless effort to partition a table with pt-online-schema-change than using the traditional Alter table in mysql client. I have been using pt-online-schema-change for years now and I must say that the result were outstanding. Recently, I’m trying to use this tool to partition my table but I have been getting some errors

( in cleanup ) Error altering new table ‘mydatabse. _mytable_new’: “DBD : : mysql : : db do failed: you have an error in your SQL syntax ; check the manual that corresponds yo your Mariadb server version for the right syntax to use near Jun 7;16:45:10 CEST 2023)
PARTITION BY RANGE (TO_DAYS(wed jun 7 16:46:10 ….::

Note: I’m thinking the partition function using is correct by the date Function (TO_DAYS) might be the issue here .

Any help

2

Hello @Dba1,
Would you like to share your table definition to give more clarity along with MariaDB version?
Also post the command that you have used for pt-online-schema-change.

Did you manually type this (just confirming about that typo)
check the manual that corresponds yo your Mariadb server version

Thanks,
K