MySQL Forums
Forum List  »  Newbie

MySQL Constraint Dump/Restore Question
Posted by: Kevin Darsney
Date: August 16, 2019 09:23AM

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?

Options: ReplyQuote


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.