any MYSql Buffs on
 

I am trying to creat a simple freakin table and it is not working, keep giving me this stupid error

http://www.ArabianGoddess.com/error2.jpg



and this is the table
http://www.ArabianGoddess.com/table.jpg

BUMP!! Promise it will never happen again

mght you be running a version that doesnt support innodb?

No, I get the same error for all storage types

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.

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