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
Article ID: 1712, Created: August 5, 2015 at 3:57 AM, Modified: August 5, 2015 at 3:57 AM