Re: MERGE tables error

2003-10-24 Thread Roger Baklund
* [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

RE: MERGE tables error

2003-10-24 Thread Victor Pendleton
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.

MERGE tables error

2003-10-24 Thread Tbird67ForSale
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