Gonzalo Villarreal gonetil

gonetil / convert_db_to_utf8.rb

Created December 18, 2019 22:17 — forked from njvack/convert_db_to_utf8.rb

	#!/usr/bin/env ruby
	require 'rubygems'
	require 'mysql2'

	Mysql2::Client.default_query_options.merge!(:as => :array)
	conn = Mysql2::Client.new(:host => 'localhost', :username => 'user',
	:password => 'pw', :database => 'db')

	tables = conn.query("SHOW TABLES").map {\|row\| row[0] }