tag:help-archives.hannonhill.com,2010-02-09:/discussions/installation/5473-myisam-tables-in-cms-databaseCascade CMS: Discussion 2015-06-17T14:33:06Ztag:help-archives.hannonhill.com,2010-02-09:Comment/369848892015-05-29T21:27:59Z2015-05-29T21:27:59ZMyISAM tables in CMS database<div><p>Hi,</p>
<p>I have configured snapshots of my CMS database in Amazon RDS and
I am getting notices that the MyISAM tables may not restore
properly. I took a look at the database and I see that
DATABASECHANGELOG & DATABASECHANGELOGLOCK are MyISAM while
everything else is InnoDB.</p>
<p>What is the significance of these tables not being restored
properly? Can I convert them to InnoDB?</p></div>amoxleytag:help-archives.hannonhill.com,2010-02-09:Comment/369848892015-06-01T15:05:42Z2015-06-01T15:05:42ZMyISAM tables in CMS database<div><p>Hi,</p>
<p>Those tables should definitely be InnoDB like all of the other
tables, so feel free to convert them over.</p>
<p>These particular tables are used by Cascade during the startup
process to compare the versions of Cascade on the application and
the database, which determines whether or not updates need to be
applied.</p>
<p>Please let me know if you have any questions.</p>
<p>Thanks!</p></div>Ryan Griffith