Re: Help with Migration/Foreign Key

2007-05-23 Thread Baron Schwartz
Hi Chris, Chris Hoover wrote: Here is the error from the show innodb status: 070523 15:39:39 Error in foreign key constraint of table mysql/#sql-d70_22: FOREIGN KEY (tab_id, class) REFERENCES system_tabs(tab_id, class): Cannot find an index in the referenced table where the referenced colum

Re: Help with Migration/Foreign Key

2007-05-23 Thread Chris Hoover
Here is the error from the show innodb status: 070523 15:39:39 Error in foreign key constraint of table mysql/#sql-d70_22: FOREIGN KEY (tab_id, class) REFERENCES system_tabs(tab_id, class): Cannot find an index in the referenced table where the referenced columns appear as the first columns,

Re: Help with Migration/Foreign Key

2007-05-23 Thread Baron Schwartz
Hi Chris, Chris Hoover wrote: I need some help. I am under presure from management to migrate and existing Sybase ASA database to Mysql for a proof of concept. I have done most of the work, but am having an issue creating a foreign key. I keep getting the "Can't create table './mysqk/#sql-d70

Help with Migration/Foreign Key

2007-05-23 Thread Chris Hoover
I need some help. I am under presure from management to migrate and existing Sybase ASA database to Mysql for a proof of concept. I have done most of the work, but am having an issue creating a foreign key. I keep getting the "Can't create table './mysqk/#sql-d70_1f.frm' (errno: 150)" error. I