Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2105
  • Last Modified:

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
0
Ryan Bayne
Asked:
Ryan Bayne
  • 4
  • 2
1 Solution
 
Alex-w474Commented:
Could you please provide a create table statement for your table?

MySQL have several database engines, MyISAM, InnoDB are examples.
The engine can be specified using ENGINE keyword in create table statement as follows:

create table table 1 (...) engine=myisam;

Open in new window

0
 
Ryan BayneWordPress DeveloperAuthor Commented:
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
CREATE TABLE sessions
(
    id varchar(32) NOT NULL,
    access int(10) unsigned,
    data text,
    PRIMARY KEY (id)
);

Open in new window

0
 
Ryan BayneWordPress DeveloperAuthor Commented:
Sorry i said using the query window causes the error but it doesnt
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Ryan BayneWordPress DeveloperAuthor Commented:
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
0
 
Ryan BayneWordPress DeveloperAuthor Commented:

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;

Open in new window

0
 
Alex-w474Commented:
So, I suppose that you can create tables using MyISAM engine with create table SQL statement, right?
If so, you should be able to create tables in MySQL Administrator when you select database type MyISAM. Database engines that are disabled (in red), can be enabled if you have access to the MySQL configuration file (my.ini), and mysql binaries, consider the following manual articles: http://dev.mysql.com/doc/refman/5.0/en/storage-engines.html and http://dev.mysql.com/doc/refman/5.0/en/innodb-configuration.html
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now