Losing data more info

create table EAP (eapID int auto_increment primary key, Name varchar(60), Addr1 varchar(50), Addr2 varchar(50), City varchar(30), State varchar(2), index state_ind(state),

Losing data

Hej I have several databases with several tables in them and all works fine except for one database that loses data. I'm running mySQL 4.0.1-alpha-nt and the tables are all INNODB. The problem is as follows: Table B references table A by a foreign key. I've filled table A with all the data I