Help with MyISAM Merge table
Guy Gordon <[email protected]> Tue, 27 Mar 2007 18:33:32 -0400
| Newsgroups | gmane.comp.db.mysql.windows |
|---|---|
| Organization | White Crane Systems |
| Message-ID | <[email protected]> |
I have a MyISAM merge table that works with MySQL 5.0.27, but fails when I try to upgrade to 5.0.37. The error is 1168: "Unable to open underlying table which is differently defined or non-MyISAM type, or doesn't exist." The problem is, they *do* exists. When I switch back to 5.0.27 everything works fine. Can anyone tell me what changed that is failing these? I can't tell exactly which version change broke this, as I missed the updates between ,27 and .37, and old binaries are not available for DL on MySQL.COM. I'm running MySQL on Windows 2003 Server, with 2Gb RAM. I guess my next step will be to switch to .37 temporarily, and print out table structures for all the tables & the merge. Maybe I can spot some difference among them (like MyISAM version) that .27 didn't care about. -- MySQL Windows Mailing List For list archives: http://lists.mysql.com/win32 To unsubscribe: http://lists.mysql.com/[email protected]