Importing mysql dumps with utf-8 charset
How to import mysql dumps with utf-8 characters without getting trouble. more >>
Contents
The mysql command
Open the shell / command line and enter the following command:
by using the --default-character-set option
you make sure that the dump is imported correctly.
mysql -u USERNAME -pPASSWORD --default-character-set=utf8 DATABASE < SQL_FILE
by using the --default-character-set option
you make sure that the dump is imported correctly.