mysql-backup4j
mysql-backup4j copied to clipboard
Dropping tables with foreign key constraints fails
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.