I need to run an alter with Percona tool but it gives error:
xml_bookingshas triggers. This tool needs to create its own triggers, so the table cannot already have triggers
So I checked the triggers like this:
show triggers like 'xml_bookings'\G;
Trigger: booking_status_update2 Event: UPDATE Table: xml_bookings Statement: BEGIN IF (OLD.backofficestatus <> NEW.backofficestatus AND left(OLD.booktime,10) <> curdate()) THEN insert into booking_status_changes set processid=new.processid, oldstatus=OLD.backofficestatus, newstatus=NEW.backofficestatus, website=NEW.website; END IF; END Timing: BEFORE Created: NULL sql_mode: Definer: root@localhost character_set_client: utf8 collation_connection: utf8_general_ci Database Collation: latin1_swedish_ci 1 row in set (0.00 sec)
ERROR: No query specified
What are the options I have? Eventually I need to use
pt-online-schema-change to altering.