Solved

How to I fix this in mysql administrator - The storage engine you selected is not enabled currently

Posted on 2008-06-18
6
2,042 Views
Last Modified: 2012-08-14
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
Comment
Question by:Ryan Bayne
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
6 Comments
 
LVL 5

Expert Comment

by:Alex-w474
ID: 21818450
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
 
LVL 2

Author Comment

by:Ryan Bayne
ID: 21818557
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
 
LVL 2

Author Comment

by:Ryan Bayne
ID: 21818574
Sorry i said using the query window causes the error but it doesnt
0
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
LVL 2

Author Comment

by:Ryan Bayne
ID: 21818595
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
 
LVL 2

Author Comment

by:Ryan Bayne
ID: 21818597

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
 
LVL 5

Accepted Solution

by:
Alex-w474 earned 250 total points
ID: 21820270
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

Featured Post

Get Database Help Now w/ Support & Database Audit

Keeping your database environment tuned, optimized and high-performance is key to achieving business goals. If your database goes down, so does your business. Percona experts have a long history of helping enterprises ensure their databases are running smoothly.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question