HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

Migrate Jira to MySql - Unknown system variable 'storage_engine'

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
jiraunknownsystemmigratestorage_enginemysqlvariable

Problem

I'm migrating JIRA in Windows from HSQL to MySQL and I got stuck with the message Unknown system variable 'storage_engine'. Though I created a backup, installed MySQL and copied J connector to libs of JIRA.

Then I set the system variable storage_engine = InnoDB and rebooted the machine but the message is still there.

Could you please point me to a good direction.

Solution

If you are using MySQL 5.6, InnoDB is already the default.

Please do not use storage-engine because it is deprecated and probably explains the error.

You should use default-storage-engine or default_storage_engine in my.cnf instead

[mysqld]
default-storage-engine = InnoDB


GIVE IT A TRY !!!

Code Snippets

[mysqld]
default-storage-engine = InnoDB

Context

StackExchange Database Administrators Q#101908, answer score: 5

Revisions (0)

No revisions yet.