KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I am trying to make Innodb as my default engine and I changed this in the my.cnf file. I set default-storage-engine=InnoDB in my.cnf file and restarted mysql but still it's not taking it. Even after restarting the server, it's still showing default engine as MyISAM. show engines +------------+---------+- | Engine | Support | +------------+---------+- | InnoDB | YES | | MRG_MYISAM | YES | | BLACKHOLE | YES | | CSV | YES | | MEMORY | YES | | FEDERATED | NO | | ARCHIVE | YES | | MyISAM | DEFAULT | +------------+---------+- How can I change it to InnoDB ?
Tags (comma-separated)
Save Edits
Cancel