In the last episode (Feb 20), Jim Lyons said:
> On Fri, Feb 20, 2009 at 12:59 AM, Krishna Chandra Prajapati wrote:
> > On Fri, Feb 20, 2009 at 5:25 AM, Jim Lyons <jlyons4435@stripped> wrote:
> >> We have 5.0.22 installed on a test machine and for some reason the
> >> innodb storage engine was not enabled. We install from RPMs so I'm not
> >> sure how to enable the storage engine. If we compiled ourselves, we'd
> >> recompile but that's not an option.
> >>
> >> Does anyone know how to enable a storage engine once mysql's been
> >> installed by an RPM? How does one make the selections in the first
> >> place with RPMs? We've always just taken what we got and it was
> >> sufficient.
> >
> > mysql rpm installation comes with default storage engine myism and
> > innodb. Just verify show engines on mysql prompt.
>
> yes, but how does one add engines to an existing install? Is it possible?
> I might want/need to add a storage engine that was not in the initial
> install.
You need MySQL 5.1 or newer:
http://dev.mysql.com/doc/refman/5.1/en/pluggable-storage.html
and even then, I don't believe any of the bundled engines are available as
plugins. It's mainly for 3rd-party engines.
--
Dan Nelson
dnelson@stripped
