MySQL Constraint Dump/Restore Question
Old RDBMS guy brand new to MySQL.
A SAAS vendor we are leaving delivered our data in a MySQL schema.sql file and a data.sql. I restored them using the community edition but the reverse engineer function finds no relationships between tables. There is no reference to CONSTRAINT or FOREIGN KEY in the schema DDL. I do see the FOREIGN_KEY_CHECKS being toggled between 0 and 1 in the comments. Am I doing something wrong in the import or did my vendor export the schema without all of the foreign key constraints?
Subject
Written By
Posted
MySQL Constraint Dump/Restore Question
August 16, 2019 09:23AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.