Over a million developers have joined DZone.

Converting Mysql Tables In InnoDB

·
// description of your code here


class ConvertMysqlToInnodb < ActiveRecord::Migration
 def self.up
   config = ActiveRecord::Base.configurations
   begin
     STDERR.puts "Migrating all existing tables to InnoDB"
     schema = []
     select_all('SHOW TABLES').inject([]) do |schema, table|
       schema << "ALTER TABLE #{table.to_a.first.last} ENGINE=InnoDB"
     end
     schema.each { |line| execute line }
   end if config[RAILS_ENV]['adapter'] == 'mysql' unless $schema_generator
 end
source http://trac.typosphere.org/browser/trunk/db/migrate/015_convert_mysql_to_innodb.rb

 def self.down
   # don't do anything
   # this is a one-way migration, but it's not "irreversable"
   # because it doesn't change any code logic
 end
end
Topics:

The best of DZone straight to your inbox.

SEE AN EXAMPLE
Please provide a valid email address.

Thanks for subscribing!

Awesome! Check your inbox to verify your email so you can start receiving the latest in tech news and resources.
Subscribe

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}