Re: ERROR 1005 - Please help

2004-08-31 Thread Mulugeta Maru
Hi Michael, I must say thank you for helping me. Yes you are right - I made the changes and it works. I will have to read the manual to further understand the issue with Primary and Foreign keys. Thank you. Maru --- Michael Stassen <[EMAIL PROTECTED]> wrote: > The problem is in table SECTIONS.

Re: ERROR 1005 - Please help

2004-08-30 Thread Michael Stassen
The problem is in table SECTIONS. From the manual, "In the referencing table, there must be an index where the foreign key columns are listed as the first columns in the same order. In the referenced table, there must be an index where the referenced columns are listed as the first columns in th

ERROR 1005 - Please help

2004-08-30 Thread Mulugeta Maru
I have posted this in a subject called - InnoDB table creation. I am just trying to be specific. Please forgive me if this is not allowed. I have searched the online help and this site. I can not find out why I am getting this error: ERROR 1005 at line 33: Can't creat table '.\enrollment1\enroll

ERROR 1005 , Please help

2003-02-14 Thread sindhu
Hi , I have a problem with the mysql database restore. When I take a backup of a database and try to restore it on a particular server(Production) , I get the following error message. ERROR 1005 at line 12: Can't create table './CloneTracking/HitPickFileMaster.frm' (errno: 150) But the same work