any MYSql Buffs on

**MBS Auto** · 03-01-2005, 05:08 PM

BUMP!! Promise it will never happen again

**lloyd** · 03-01-2005, 05:15 PM

mght you be running a version that doesnt support innodb?

**MBS Auto** · 03-01-2005, 05:20 PM

No, I get the same error for all storage types

**fr8** · 03-01-2005, 05:27 PM

First mistake. Your using windows.

Second im not sure about. I do know that an INNODB type table is for the hotbackup software that you can buy for a mysql database. do you have the that intalled? if so it should work like so.

CREATE TABLE `goddess` (
`id` INT( 10 ) NOT NULL AUTO_INCREMENT ,
`username` VARCHAR( 16 ) NOT NULL ,
`password` VARCHAR( 16 ) NOT NULL ,
`email` VARCHAR( 25 ) NOT NULL ,
PRIMARY KEY ( `id` )
) TYPE = INNODB ;

im not sure how you would add this through the gui but that is the commandline for the new table.

**fr8** · 03-01-2005, 05:31 PM

CREATE TABLE `dbusers` (
`id` INT( 10 ) NOT NULL AUTO_INCREMENT ,
`username` VARCHAR( 16 ) NOT NULL ,
`password` VARCHAR( 16 ) NOT NULL ,
`email` VARCHAR( 25 ) NOT NULL ,
PRIMARY KEY ( `id` )
) TYPE = INNODB ;

just noticed goddess was the database

any MYSql Buffs on

any MYSql Buffs on

Comment

Comment

Comment

Comment

Comment