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,051 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
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 
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

Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

Question has a verified solution.

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

This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
By, Vadim Tkachenko. In this article we’ll look at ClickHouse on its one year anniversary.
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

630 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