Ryan Bayne
asked on
How to I fix this in mysql administrator - The storage engine you selected is not enabled currently
I had this message once before but briefly. A restart probably fixed it but not this time.
The storage engine you selected is not enabled currently
It appears when I attempt to create a new table in MySQL Admin
thanks for any help
The storage engine you selected is not enabled currently
It appears when I attempt to create a new table in MySQL Admin
thanks for any help
ASKER
Well I was using manual controls to create the table no statement.
It would however be something like below...
which also causes the error. At the moment I think its InnoDB and when I access the list of them many of them are in red including InnoDB.
I've not made changes to MySQL admin can anything locally cause it
It would however be something like below...
which also causes the error. At the moment I think its InnoDB and when I access the list of them many of them are in red including InnoDB.
I've not made changes to MySQL admin can anything locally cause it
CREATE TABLE sessions
(
id varchar(32) NOT NULL,
access int(10) unsigned,
data text,
PRIMARY KEY (id)
);
ASKER
Sorry i said using the query window causes the error but it doesnt
ASKER
OK heres an existing table, so I could probably create tables still however I'd still like to know whats causing this so I can use manual abilitys in the admin interface
ASKER
DROP TABLE IF EXISTS `webtg2008`.`users`;
CREATE TABLE `webtg2008`.`users` (
`id` int(11) NOT NULL auto_increment,
`uname` varchar(25) NOT NULL default '',
`fname` varchar(30) NOT NULL default '',
`lname` varchar(20) NOT NULL default '',
`email` varchar(45) NOT NULL default '',
`country` varchar(20) default NULL,
`zipcode` bigint(20) default NULL,
`datejoined` datetime default NULL,
`passwd` varchar(32) NOT NULL,
`access` varchar(15) NOT NULL default 'member',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
MySQL have several database engines, MyISAM, InnoDB are examples.
The engine can be specified using ENGINE keyword in create table statement as follows:
Open in new window