InnoDB to MyISAM in CWP

InnoDB to MyISAM in CWP

Hello,

 

It’s very easy to change default storage engine from InnoDB to MyISAM in CWP.

Just follow below steps 

Login into the server via SSH
Open /etc/my.cnf file 

Add below line
default-storage-engine=MyISAM

 

Below is the example of modified file 

#
# include all files from the config directory
#
!includedir /etc/my.cnf.d
[mysqld]
default-storage-engine=MyISAM
innodb_file_per_table=1
performance-schema=0
default-time-zone = ‘+05:30’




Share on Pinterest
Share on LinkedIn
Share on WhatsApp
Share on Telegram