Thanks for the tip.
Simple problem, my innodb data file was created with the default my.cnf.
When I started it with the large_table version, it used different innodb
table space size. Therefore would not start :)
Cheers,
Ben
Dan Buettner wrote:
Ben, looks like you've either got it disable
Thanks for the excellent reference, this gives me a lot to go on.
My server is in bits at the moment, I'll let you know when it's up again!
Ben
Dan Buettner wrote:
Ben, looks like you've either got it disabled in my.cnf or with a
startup flag, or you've not set all the needed options for InnoD
Ben, looks like you've either got it disabled in my.cnf or with a
startup flag, or you've not set all the needed options for InnoDB.
See http://dev.mysql.com/doc/refman/5.0/en/mysqld-max.html, near the
bottom of the page it explains what DISABLED means and refers you to the
error log for messa
Hi Dan,
This is what I have. What does this mean with regards to InnoDB?
++--++--+-++
| Engine | Support | Comment
| Transactions | XA | Savepoints |
+---
Ben, what does SHOW ENGINES show you? It should list all known storage
engines and indicate whether your MySQL install supports it or not.
Here's mine (5.0.21) for comparison; I was able to create a test table
as InnoDB and the SHOW CREATE showed it as InnoDB:
-> show engines;
++
Hi Gerald,
I am sure I don't have this in my my.cfg. I am using the supplied
'large table' my.cfg. The *only* innodb option I have is the command
line parameter to mysqld:
--innodb
If anybody has any other options about how to get innodb working in
5.1.9, I'd be very interested!
Thanks
Hi Gerald,
I am sure I don't have this in my my.cfg. I am using the supplied
'large table' my.cfg. The *only* innodb option I have is the command
line parameter to mysqld:
--innodb
If anybody has any other options about how to get innodb working in
5.1.9, I'd be very interested!
Thanks
Ben Clewett wrote:
Dear MySQL,
I've installed 5.1.9 from source on a SUSE 10 box. But I can't get
InnoDB tables respected.
I have used the correct compilation flag (--with-innodb).
SHOW VARIABLES; lists all the usual innodb variables.
The innodb table space has been created in ~/var/ibdata1
TED]
Sent: Tuesday, 23 May 2006 5:50 PM
To: Logan, David (SST - Adelaide)
Cc: mysql@lists.mysql.com
Subject: Re: InnoDB problems under 5.1.9
Logan, David (SST - Adelaide) wrote:
Hi Ben,
Try doing
SHOW ENGINES;
Here: (pertinent cols only)
++--+--+-+
t: Re: InnoDB problems under 5.1.9
Logan, David (SST - Adelaide) wrote:
> Hi Ben,
>
> Try doing
>
> SHOW ENGINES;
Here: (pertinent cols only)
++--+--+-++
| Engine | Support | Transaction
t
---
-Original Message-
From: Ben Clewett [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 23 May 2006 4:57 PM
To: mysql@lists.mysql.com
Subject: InnoDB problems under 5.1.9
Dear MySQL,
I've installed 5.1.9 from source on a SUSE 10 box. But I can't get
ewett [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 23 May 2006 4:57 PM
To: mysql@lists.mysql.com
Subject: InnoDB problems under 5.1.9
Dear MySQL,
I've installed 5.1.9 from source on a SUSE 10 box. But I can't get
InnoDB tables respected.
I have used the correct compilation flag (--wit
Dear MySQL,
I've installed 5.1.9 from source on a SUSE 10 box. But I can't get
InnoDB tables respected.
I have used the correct compilation flag (--with-innodb).
SHOW VARIABLES; lists all the usual innodb variables.
The innodb table space has been created in ~/var/ibdata1.
But if I enter:
C
13 matches
Mail list logo
