Re: setting up innodb

[bob lambert]

Well, I figured out how to set the variables in my.cnf:

default-storage-engine=innodb
default-table-type=innodb

But it does not seem to help. I completely erased all my tables from db, reloaded from SQL and then vomited it back out. For some reason the distinction that the tables are INNODB is lost.

here is an example input:

USE mydatabase;
SET FOREIGN_KEY_CHECKS = 0;
DROP TABLE IF EXISTS `tblformatreports`;
CREATE TABLE `tblformatreports` (
`formatreportid` int(10) unsigned NOT NULL auto_increment,
`id` int(10) unsigned NOT NULL default '0',
`subdataloc` int(11) NOT NULL default '0',
`maxlinespage` int(11) default NULL,
`linethickness` int(11) default NULL,
`fglinethickness` int(11) default NULL,
`pslinethickness` int(11) default NULL,
`pslinetype` int(11) default NULL,
`lshyperlinks` enum('Y','N') NOT NULL default 'Y',
`formatreports_spare1` int(11) default NULL,
`formatreports_spare2` int(11) default NULL,
`formatreports_spare3` int(11) default NULL,
PRIMARY KEY (`formatreportid`),
INDEX `tblmain_ind` (`id`),
FOREIGN KEY (`id`) REFERENCES tblmain (`id`)
ON UPDATE CASCADE ON DELETE CASCADE
) ENGINE=INNODB ;

...
...

here is the regurgitated version:


DROP TABLE IF EXISTS `tblformatreports`;
CREATE TABLE "tblformatreports" (
"formatreportid" int(10) unsigned NOT NULL,
"id" int(10) unsigned NOT NULL default '0',
"subdataloc" int(11) NOT NULL default '0',
"maxlinespage" int(11) default NULL,
"linethickness" int(11) default NULL,
"fglinethickness" int(11) default NULL,
"pslinethickness" int(11) default NULL,
"pslinetype" int(11) default NULL,
"lshyperlinks" enum('Y','N') NOT NULL default 'Y',
"formatreports_spare1" int(11) default NULL,
"formatreports_spare2" int(11) default NULL,
"formatreports_spare3" int(11) default NULL,
PRIMARY KEY ("formatreportid"),
KEY "tblmain_ind" ("id")
) AUTO_INCREMENT=18 ;

...
...

ALTER TABLE `tblformatreports`
ADD CONSTRAINT "tblformatreports_ibfk_1" FOREIGN KEY ("id") REFERENCES "tblmain" ("id") ON DELETE CASCADE ON UPDATE CASCADE;


Sure would like to know what I am doing wrong.

Thanks
Bob