Page 1 of 1
Foreign keys lost after converting from ACCESS to MySQL
Posted: Fri Aug 22, 2008 12:44 pm
by frank.quosdorf
After converting from ACCESS (2003) to MySQL (INNODB, MySQL 5.1), all foreign keys (references) are lost. Is there a setting that needs to be configured?
Thanks, Frank
Re: Foreign keys lost after converting from ACCESS to MySQL
Posted: Sat Aug 23, 2008 4:01 pm
by jr
Primary and secondary indexes should be moved to MySQL.
Regards,
Jacob
Re: Foreign keys lost after converting from ACCESS to MySQL
Posted: Thu Oct 23, 2008 12:43 pm
by Pegsneggle
I have the same problem. As far as I can see, there is only one reference to index during the conversion process. I have made sure the tick remains in that box, but still no foreign key settings are created. What am I doing wrong?