* [EMAIL PROTECTED]
[...]
>ERROR 1016: Can't open file: 'new_master.MRG'. (errno: 143)
>
> All table structures are identical.
Maybe not..? :)
> Am I missing a basic error numbers page in the online docs? I've found a
> few, but nothing comprehensive, like a page where I can enter an
> error
Error 143 suggests that you have conflicting table definitions.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, October 24, 2003 7:08 AM
To: [EMAIL PROTECTED]
Subject: MERGE tables error
I've created several merge tables from the command prompt.
I've created several merge tables from the command prompt. All seems well,
the .frm and .MRG files are created. The contents of the .MRG files are
accurate.
I flushed the tables (even restarted MySQL).
I can see the newly created merge tables, but when I try to run a DESCRIBE or
a SELECT