Not the answer you need?
Register and ask your own question!

pt-online-schema-change: MySQL error 1452

ay123ay123 EntrantCurrent User Role Novice

I tried to add a null string column to an existing table using pt-online-schema-change with --alter-foreign-keys-method option. I've tried values: auto, drop_swap, and rebuild_constraints since I want to keep the foreign keys after adding the new column, I still get the same MySQL error 1452 below. Any idea why the error occurred?
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.