Hello.
With 'set foreign_key_checks=0' creation of the table works on
my 4.1.11. Execute:
set foreign_key_checks=0;
Then create `shift` and all corresponding tables and
set foreign_key_checks=1;
"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote:
>
> Thank you for your help. I
Thank you for your help. I really appreciate it.
I created the dump with --quote-names option, but this does not solve the
problem unfortunately. I still get error:
C:\xampp\xampp\mysql\bin>mysql -uroot db2 < test5.txt
ERROR 1005 at line 54: Can't create table '.\db2\shift.frm' (errno: 150)
C