mysql> show variables like '%charac%';
+--------------------------+-------------------------------------------+
| Variable_name            | Value                                     |
+--------------------------+-------------------------------------------+
| character_set_client     | utf8                                      |
| character_set_connection | utf8                                      |
| character_set_database   | utf8                                      |
| character_set_filesystem | binary                                    |
| character_set_results    | utf8                                      |
| character_set_server     | latin1                                    |
| character_set_system     | utf8                                      |
| character_sets_dir       | /rdsdbbin/mysql-5.6.21.R1/share/charsets/ |
+--------------------------+-------------------------------------------+
8 rows in set (0.11 sec)

mysql> show variables like '%collation%';
+----------------------+-------------------+
| Variable_name        | Value             |
+----------------------+-------------------+
| collation_connection | utf8_general_ci   |
| collation_database   | utf8_general_ci   |
| collation_server     | latin1_swedish_ci |
+----------------------+-------------------+
3 rows in set (0.05 sec)

# mysqldump --opt --default-character-set=latin1 --skip-set-charset -p db_latin1 -u user > latin1.sql

# sed -i 's/latin1/utf8/g' latin1.sql

# iconv -f latin1 -t utf-8 < latin1.sql > utf8.sql

# mysql --default-character-set=utf8 -u user -p db_utf8 < utf8.sql

mysql> create database db_utf8 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

mysql> show create table t1\G;
*************************** 1. row ***************************
       Table: t1
Create Table: CREATE TABLE `t1` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `page_title` varchar(250) DEFAULT NULL,
  `keywords` varchar(255) DEFAULT NULL,
  `description` blob,
  `file_name` varchar(50) DEFAULT NULL,
  `page_content_2` blob,
  `page_content_3` blob,
  `page_content` blob,
  `update_date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=utf8
1 row in set (0.06 sec)