Error while running migration script tool
I've ran the migration script to migrate my platform from 6.3.2 to 7 and in the sequence of steps, I get an error:
Failed to execute:
[ Migrating 2/7 ]
| Description : Update Business Data
DROP TABLE ref_biz_data_inst
because: Cannot delete or update a parent row: a foreign key constraint fails
Before running the migration script, I backed up mySQL database. I ran the backup SQL script which ran successfully.
While running the migration script, it's trying to do an update but failing due to the foreign key constraint. Does anyone know how to get around this error? It's obvious that the backup mysql script is not checking for foreign keys and handling them when an update occurs.