How to resume pt-online-schema-change stopped by SIGINT?

Hello, i attempt to add column on table through pt-online-schema-change. It took very long so i stopped it using SIGINT signal. I want to resume it now but after rerun the same command it tells :

No slaves found.  See --recursion-method if host ip-x-x-x-x has slaves.
Not checking slave lag because no slaves were found and --check-slave-lag was not specified.
The table `my_database`.`my_table` has triggers.  This tool needs to create its own triggers, so the table cannot already have triggers.

Is there a way to resume it without removing all triggers and table created by pt-online-schema-change Thanks in advance.

1 Like

Hello Hanania,

Unfortunately pt-osc doesn’t have this feature, and you need to run it from scratch :frowning:

Regards,
Denis Subbota.
Managed Services, Percona.

1 Like