mysql-backup4j icon indicating copy to clipboard operation
mysql-backup4j copied to clipboard

Dropping tables with foreign key constraints fails

Open angusvb opened this issue 3 years ago • 0 comments

When trying to restore a database that has foreign key constraints - with dropExisting enabled - the MysqlImportService returns e.g.: Cannot drop table 'address' referenced by a foreign key constraint 'FKditu6lr4ek16tkxtdsne0gxib' on table 'users'.

Probably needed to disable foreign key checks before executing the drop.

angusvb avatar Oct 25 '21 08:10 angusvb