03-05-2017, 10:40 AM
I see you have commented directives before the table definition. These are applied as they are found. So if you have the one we need at the top:
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
and then after that assignment you have another one that undoes that, maybe something like this:
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=1 */;
then you will have this problem. In other words, search your dump for the FOREIGN_KEY_CHECKS directive and make sure you have only one at the top that deactivates it
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
and then after that assignment you have another one that undoes that, maybe something like this:
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=1 */;
then you will have this problem. In other words, search your dump for the FOREIGN_KEY_CHECKS directive and make sure you have only one at the top that deactivates it
Joe
TSolucio
TSolucio