How to restore mysql database with non-english characters?

In order to avoid problems with data that has non-english characters, you may   1. open sql dump file via notepad or notepad++ 2. add this line to the top of the dump file:

/*!40101 SET NAMES utf8 */;

3. save file with utf-8 format 4. restore it from hosting control panel