Hi Jim, all!
Jim Lyons wrote: > Yes, I had a slip of the mind. The engine that was not supported by the > install is the Federated engine. I apologize, I had a blind spot. The > "SHOW ENGINES" command lists FEDERATED but has NO in the Support column. > > The question, though, is how does one add an unsupported engine to an RPM > install? Is it possible? Otherwise I have to either compile from source or > upgrade to a version that I hope will have it. You cannot add an engine later to a MySQL 5.0 binary. This will change with newer versions when plugins can be used for table handlers. > > On Thu, Feb 19, 2009 at 10:08 PM, Baron Schwartz <ba...@xaprb.com> wrote: > >> [[...]] >> >> On Thu, Feb 19, 2009 at 6:58 PM, Jim Lyons <jlyons4...@gmail.com> wrote: >>> [[...]] >>> >>> We have 5.0.22 installed on a test machine and for some reason the innodb >>> storage engine was not installed with it. We install from RPMs [[...]] Let me repeat: 5.0.22 on a test machine? We built those binaries in May, 2006, so they are nearly three years old by now. Are your tests that thorough? I checked the logs, and I found that for some reason which I really don't know any more the "federated" engine was not configured in that version. The oldest community builds in which I find it configured are 5.0.41 and 5.0.45, which you can still get from the archive (accessible via the download page). There were some issues with "federated" which later caused us to disable it by default, so it is configured in recent versions but not enabled in the "my.cnf" coming with the packages. Some more info can be found in bug report #37069: http://bugs.mysql.com/bug.php?id=37069 Whatever you decide about "federated", you definitely should upgrade from 5.0.22 to some current versions - there were several important bugfixes (including security issues) which you are lacking. And in your next posting, please specify exactly which packages you are using - platforms *do* make a difference in some cases. HTH, Jörg -- Joerg Bruehe, MySQL Build Team, joerg.bru...@sun.com Sun Microsystems GmbH, Sonnenallee 1, D-85551 Kirchheim-Heimstetten Geschaeftsfuehrer: Thomas Schroeder, Wolfgang Engels, Dr. Roland Boemer Vorsitzender des Aufsichtsrates: Martin Haering Muenchen: HRB161028 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org