MySQL Forums
Forum List  »  General

Re: What Foreign Key?
Posted by: Peter Brawley
Date: October 17, 2016 12:27PM

> I can't include a screen print that would show what entered and the error message in context.

Right, you'll need to copy & paste text. Easiest to do from the mysql client.

Since I can't replicate the error, you'll need to. One way: mysqldump the db, then load it under a different name and see if the create table script elicits the error. If it does not, the likelihood is that the original db is corrupted. If it does, pare down the db, table by table, until the error disappears, at which point you have a way of replicating the error: dump that db and post the result.

Options: ReplyQuote


Subject
Written By
Posted
October 12, 2016 08:39AM
October 16, 2016 04:25PM
October 17, 2016 06:40AM
October 17, 2016 09:50AM
October 17, 2016 10:50AM
Re: What Foreign Key?
October 17, 2016 12:27PM
October 17, 2016 01:18PM


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.