Migration to convert the DB to UTF8

convert_db_to_utf8.rb

class ConvertDbToUtf8 < ActiveRecord::Migration

  def self.up
    if Rails.env.production?
      db_config = ActiveRecord::Base.connection.instance_values["config"]
      db_name = db_config[:database]
      db_user = db_config[:username]
      db_pass = db_config[:password] || ''

      latin1_dump = 'latin1_dump.sql'
      utf8_dump   = 'utf8_dump.sql'


      print "Dumping database... "
      system "mysqldump --user=#{db_user} --password='#{db_pass}' --add-drop-table --default-character-set=latin1 --insert-ignore --skip-set-charset #{db_name} > #{latin1_dump}"
      puts "done"

      print "Converting dump to UTF8... "
      system "iconv -f ISO-8859-1 -t UTF-8 #{latin1_dump} | sed 's/latin1/utf8/' > #{utf8_dump}"
      puts "done"

      print "Recreating database..."
      system "mysql --user=#{db_user} --password='#{db_pass}' --execute=\"DROP DATABASE #{db_name};\""
      system "mysql --user=#{db_user} --password='#{db_pass}' --execute=\"CREATE DATABASE #{db_name} CHARACTER SET utf8 COLLATE utf8_unicode_ci;\""
      puts "done"

      print "Importing UTF8 dump..."
      system "mysql --user=#{db_user} --password='#{db_pass}' --default-character-set=utf8 #{db_name} < #{utf8_dump}"
      puts "done"

      puts " *** don't forget to delete temp files #{latin1_dump} and #{utf8_dump}"
    end
  end

  def self.down
  end

end