MySQL command line import of file with UTF-8 encoding

A Post-It note for me …

Importing an UTF-8 encoded MySQL Database export file with MySQL command line interface:

mysql -D databasename -h hostname -p -u db_username --default_character_set utf8 < sqlfile.sql

If you don’t add the “–default_character_set utf8″ flag you will get very funny characters in your database :-)

Leave a comment

0 Comments.

Leave a Reply


[ Ctrl + Enter ]