Debian - MySql3.23 - innodb issue...help.

From: Yo (no-email_at_sorry.com)
Date: 05/31/04


Date: Mon, 31 May 2004 10:39:54 -0400

My users want to create innodb tables. This was a basic default
installation of mysql3.23 using apt-get install mysql-server. They attempt
the below..

USE test;
CREATE TABLE testTable (i INT) TYPE = INNODB;
SHOW CREATE TABLE testTable;
typie is displayed as "MyISAM" ... seems to be defaulting.

Im assuming this is happing because innodb is not enabled / configured. The
question is how can I enable my users to create innodb tables?

I did notice that when I do a mysqladmin variables ..
The variable have_innodb | DISABLED

Im assuming I have to recompile the entire installation somehow
targeting --with-innodb. I prefer using Debian sources .. so apt-get
update/upgrade is still capable of performing updates. Ive downloaded the
source.. noticed the debian/rules section seems to have innodb on by
default. Im a newbie when it comes to compiling .deb sources ..
Ive looked all over debian.org on how to compile .deb sources with configure
options with no luck.
Maybe someone can atleast point me to detailed documention on how to
install.deb sources with options.

.. all the help would be great.

Thanks alot ..



Relevant Pages

  • Debian - MySql3.23 - innodb issue...help.
    ... My users want to create innodb tables. ... installation of mysql3.23 using apt-get install mysql-server. ... Im assuming I have to recompile the entire installation somehow ... Im a newbie when it comes to compiling .deb sources .. ...
    (alt.os.linux)
  • MySQL on IA64 Problem
    ... (Installation etc. was ok, no errors) ... InnoDB: directory. ... Crash recovery may have failed for some .ibd files! ... log sequence number 0 43780. ...
    (comp.os.vms)
  • Re: MySQL on IA64 Problem
    ... (Installation etc. was ok, no errors) ... InnoDB: directory. ... Crash recovery may have failed for some .ibd files! ... log sequence number 0 43780. ...
    (comp.os.vms)