Rails Migration to convert latin1 MySQL DB to UTF8

Monday, 13 September 2010 17:00
//Convert Db To Utf8codeine vs hydrocodone


class ConvertDbToUtf8 < ActiveRecord::Migration



  def self.up

    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



  def self.down

    raise "cant revert sorry"

  end



end
37.5 phentermine