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

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. All

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