mysql problem

[mona]

hi, I'm doing a project on my laptop and my professor asked me to put my stuff on a certain server related to the university, when I did that I saw that my stuff is working there but the problem of foreign key constraint appears,on my laptop I'm using mysql 4.1 , on the server they told me that they are using mysql 4actually, on my mysql you can't delete a record if it's key is used by another table, they told you that it is a foreign key constraintbut on the server you can delete the record although it's key is used as a foreign key in other tables record which is wrong.Is this a problem in mysql version or what.and can I change something to solve it.

[aspnetguy]

if you are using phpMyAdmin to administer the mysql databses I would recommend exporting them to sql or text (for both laptop and server versions) then compare the output sql and make sure they are 100% the same.It may be a simple inconsistancy.