unknown variable 'default-storage-engine=myisam'

mysql myisam storage-engines
Dr.Seuss picture Dr.Seuss · Aug 30, 2012 · Viewed 14.9k times · Source

I am trying to configure Mysql (Ver 14.15 Distrib 6.0.8-alpha, for Win64) to use MyISAM as the default storage engine on Windows 7. I've created C:\my.cnf with the following contents:

[mysql]
default-storage-engine=myisam

And after restarting the mysql service and attempting to run mysql from the console, I get the following error message:

mysql: unknown variable 'default-storage-engine=myisam'

I've been working from tutorials and have copied and pasted the above directly into my my.cnf file.

I've tried a combination of the following:

set default-storage-engine=myisam
storage-engine=mysiam
set storage-engine=mysiam

Answer

jsist picture jsist · Aug 30, 2012

I tried changing it and it worked for me.

What I did was simply changed the value from "INNODB" to "MYISAM" in [mysqld] group as follows

from

default-storage-engine=INNODB

to

default-storage-engine=MYISAM

Note: its [mysqld] group not [mysql] group. [mysql] group is for MySQL client, not for server.

Alternatively, you can change default storage engine by executing 

"set global storage_engine=MYISAM"

You will not be required to restart the server in this case.

Hope it helps....

Related questions

How do I know if a mysql table is using myISAM or InnoDB Engine?

In MySQL, there is no way to specify a storage engine for a certain database, only for single tables. However, you can specify a storage engine to be used during one session with: SET storage_engine=InnoDB; So you don't …

Read More
How can I check MySQL engine type for a specific table?

My MySQL database contains several tables using different storage engines (specifically myisam and innodb). How can I find out which tables are using which engine?

Read More
How to properly create composite primary keys - MYSQL

Here is a gross oversimplification of an intense setup I am working with. table_1 and table_2 both have auto-increment surrogate primary keys as the ID. info is a table that contains information about both table_1 and table_2. table_1 (id, field) …

Read More