MySQL Forums
Forum List  »  InnoDB

Re: setting up innodb
Posted by: bob lambert
Date: March 29, 2005 06:06PM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
5147
March 28, 2005 07:15PM
Re: setting up innodb
2284
March 29, 2005 06:06PM
2177
May 20, 2005 01:11PM
2252
July 08, 2005 04:31AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.