From: Dan Nelson Date: February 20 2009 5:01pm Subject: Re: enabling storage engine with RPM install List-Archive: http://lists.mysql.com/mysql/216401 Message-Id: <20090220170126.GA45976@dan.emsphone.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii 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 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