Foreign keys lost after converting from ACCESS to MySQL

General usage of Access to MySQL

Moderator: jr

Foreign keys lost after converting from ACCESS to MySQL

Postby frank.quosdorf » Fri Aug 22, 2008 12:44 pm

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
frank.quosdorf
 
Posts: 1
Joined: Fri Aug 22, 2008 12:41 pm

Re: Foreign keys lost after converting from ACCESS to MySQL

Postby jr » Sat Aug 23, 2008 4:01 pm

Primary and secondary indexes should be moved to MySQL.

Regards,
Jacob
jr
Site Admin
 
Posts: 491
Joined: Sun Mar 26, 2006 12:28 pm

Re: Foreign keys lost after converting from ACCESS to MySQL

Postby Pegsneggle » Thu Oct 23, 2008 12:43 pm

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?
Pegsneggle
 
Posts: 3
Joined: Thu Oct 23, 2008 12:10 pm


Return to General

Who is online

Users browsing this forum: No registered users and 2 guests

cron