Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Cross posted from Stack Overflow, since this is probably more of a server admin type of issue:

Running MySQL v'5.1.12-beta-community-nt' on Windows 2k server.

I have a group of 5 tables (a,b,c,d,e) where 'b' has a foreign key to 'a' with the action "on delete cascade" c has a FK to b with the same action, and on down the line.

All tables are InnoDB.

On server restart the FK actions are getting dropped. Not the FKs themselves, just the "on delete" action. so I still have the FK constraint but no longer have any on delete action causing errors when I try to delete as it would orphan children.

Any ideas why this is happening?

share|improve this question

1 Answer 1

The first GA version of MySQL 5.1 was 5.1.30.

You are using 5.1.12-beta-community.

Please upgrade to the lastest 5.1 or even better 5.5.10 !!!

In addition, always read release notes of MySQL versions before you install to see what bugs have been fixed (or what still needs fixing)

share|improve this answer
    
Thanks, will make the suggestion to our sys admin. I unfortunately don't have control over this :( –  invertedSpear Apr 5 '11 at 21:41

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.