Script to convert every WebGUI except assetIndex table from MyISAM to InnoDB.

perlDreamer · perlDreamer · commit 288adcfd1768 · 2011-11-24T10:31:54.000-08:00
diff --git a/share/upgrades/7.10.23-8.0.0/zzzz_convertToInnoDb.pl b/share/upgrades/7.10.23-8.0.0/zzzz_convertToInnoDb.pl
@@ -0,0 +1,15 @@
+
+use WebGUI::Upgrade::Script;
+
+start_step "Convert all tables except assetIndex to InnoDB";
+
+my $get_table = session->db->table_info('', '', '%', 'TABLE');
+
+TABLE: while ( my $table = $get_table->fetchrow_hashref() ) {
+    next TABLE if $table->{TABLE_NAME} eq 'assetIndex';
+    session->db->write("ALTER TABLE ". $table->{TABLE_NAME}. " ENGINE=InnoDB");
+}
+
+
+done;
+
