Mysql Change current database characterset

Assuming you have a database with default character set latin-1 & wish to convert it to utf-8, it is very simple to convert it without any external tool

1. Dump the database:

parameter –compatible=mysql40 is to dump the database without charset settings.

2. Create a database utf8 default:

3. Reimport the database

Now you have received the utf8 character set database_new.