patternsqlMinor
Migrate Jira to MySql - Unknown system variable 'storage_engine'
Viewed 0 times
jiraunknownsystemmigratestorage_enginemysqlvariable
Problem
I'm migrating JIRA in Windows from HSQL to MySQL and I got stuck with the message
Then I set the system variable
Could you please point me to a good direction.
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
GIVE IT A TRY !!!
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 = InnoDBGIVE IT A TRY !!!
Code Snippets
[mysqld]
default-storage-engine = InnoDBContext
StackExchange Database Administrators Q#101908, answer score: 5
Revisions (0)
No revisions yet.