This guide is only for Yclas Self Hosted!

MyISAM will be deprecated in future versions of MySQL and you may need to convert tables from MyISAM to InnoDB if you are running a version of Yclas self-hosted below 3.0.

If you want to move from MyIsam to innodb, please execute these SQLs:

ALTER TABLE oc2_visits ENGINE=InnoDB;
ALTER TABLE oc2_users ENGINE=InnoDB;
ALTER TABLE oc2_subscriptions ENGINE=InnoDB;
ALTER TABLE oc2_subscribers ENGINE=InnoDB;
ALTER TABLE oc2_roles ENGINE=InnoDB;
ALTER TABLE oc2_reviews ENGINE=InnoDB;
ALTER TABLE oc2_posts ENGINE=InnoDB;
ALTER TABLE oc2_plans ENGINE=InnoDB;
ALTER TABLE oc2_orders ENGINE=InnoDB;
ALTER TABLE oc2_messages ENGINE=InnoDB;
ALTER TABLE oc2_locations ENGINE=InnoDB;
ALTER TABLE oc2_forums ENGINE=InnoDB;
ALTER TABLE oc2_favorites ENGINE=InnoDB;
ALTER TABLE oc2_crontab ENGINE=InnoDB;
ALTER TABLE oc2_coupons ENGINE=InnoDB;
ALTER TABLE oc2_content ENGINE=InnoDB;
ALTER TABLE oc2_config ENGINE=InnoDB;
ALTER TABLE oc2_categories ENGINE=InnoDB;
ALTER TABLE oc2_ads ENGINE=InnoDB;
ALTER TABLE oc2_access ENGINE=InnoDB;
ALTER TABLE oc2_config CHANGE config_value config_value MEDIUMTEXT;
ALTER TABLE oc2_content CHANGE description description MEDIUMTEXT;
ALTER TABLE oc2_plans CHANGE description description MEDIUMTEXT;
ALTER TABLE oc2_posts CHANGE description description MEDIUMTEXT;