Re: enabling storage engine with RPM install

2009-02-20 Thread Dan Nelson
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 f

Re: enabling storage engine with RPM install

2009-02-20 Thread Jim Lyons
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. On Fri, Feb 20, 2009 at 12:59 AM, Krishna Chandra Prajapati < prajapat...@gmail.com> wrote: > Hi Jim, > > mysql rpm installation comes with def

Re: Resend: enabling storage engine with RPM install

2009-02-20 Thread John Daisley
Jim, Where did you get your RPM from? Regards John > Sorry, but I'm resending because I made a mistake in terminology and want > to > be clear. The problem isn't that innodb is "DISABLED" on the database. > The > innodb engine is not supported by the database. > > We have 5.0.22 installed on a

Re: Resend: enabling storage engine with RPM install

2009-02-20 Thread Joerg Bruehe
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

Re: Resend: enabling storage engine with RPM install

2009-02-19 Thread Krishna Chandra Prajapati
gt; use-manager > > > On Thu, Feb 19, 2009 at 11:24 PM, wrote: > > > Can you post you my.cnf please > > > > Sent via BlackBerry from T-Mobile > > > > -- > > *From*: Jim Lyons > > *Date*: Thu, 19 Feb 2009 23:06:33 -

Re: enabling storage engine with RPM install

2009-02-19 Thread Krishna Chandra Prajapati
Hi Jim, mysql rpm installation comes with default storage engine myism and innodb. Just verify show engines on mysql prompt. 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 instal

Re: Resend: enabling storage engine with RPM install

2009-02-19 Thread chaim . rieger
The answer is no Sent via BlackBerry from T-Mobile -Original Message- From: Jim Lyons Date: Thu, 19 Feb 2009 23:50:13 To: Cc: MySQL Subject: Re: Resend: enabling storage engine with RPM install What configuration parameter in the config file could have an impact on whether a

Re: Resend: enabling storage engine with RPM install

2009-02-19 Thread Jim Lyons
a BlackBerry from T-Mobile > > -- > *From*: Jim Lyons > *Date*: Thu, 19 Feb 2009 23:06:33 -0600 > *To*: > > *Subject*: Re: Resend: enabling storage engine with RPM install > How does one do that in my.cnf? > > It is possible to dis

Re: Resend: enabling storage engine with RPM install

2009-02-19 Thread chaim . rieger
Can you post you my.cnf please Sent via BlackBerry from T-Mobile -Original Message- From: Jim Lyons Date: Thu, 19 Feb 2009 23:06:33 To: Cc: MySQL Subject: Re: Resend: enabling storage engine with RPM install How does one do that in my.cnf? It is possible to disable a supported

Re: Resend: enabling storage engine with RPM install

2009-02-19 Thread Jim Lyons
y.cnf. I would love it, if I could, though. On Thu, Feb 19, 2009 at 10:47 PM, wrote: > Perhaps you disabled it via my.cnf > > > Sent via BlackBerry from T-Mobile > > -Original Message- > From: Jim Lyons > > Date: Thu, 19 Feb 2009 22:45:01 > To: MySQL > S

Re: Resend: enabling storage engine with RPM install

2009-02-19 Thread chaim . rieger
Perhaps you disabled it via my.cnf Sent via BlackBerry from T-Mobile -Original Message- From: Jim Lyons Date: Thu, 19 Feb 2009 22:45:01 To: MySQL Subject: Re: Resend: enabling storage engine with RPM install Yes, I had a slip of the mind. The engine that was not supported by the

Re: Resend: enabling storage engine with RPM install

2009-02-19 Thread Jim Lyons
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 instal

Re: Resend: enabling storage engine with RPM install

2009-02-19 Thread Baron Schwartz
Where on earth did you get an RPM that doesn't have InnoDB support? I find this unlikely. I think it is more likely that you have some configuration error that's causing InnoDB to disable itself on start. How do you know InnoDB isn't supported? And by "isn't supported" I mean "isn't compiled int

Resend: enabling storage engine with RPM install

2009-02-19 Thread Jim Lyons
Sorry, but I'm resending because I made a mistake in terminology and want to be clear. The problem isn't that innodb is "DISABLED" on the database. The innodb engine is not supported by the database. We have 5.0.22 installed on a test machine and for some reason the innodb storage engine was not

enabling storage engine with RPM install

2009-02-19 Thread Jim Lyons
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