encoding

MySQL command line import of file with UTF-8 encoding

2 July 2009 sebastian Linux, 0

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

database, Datenbank, encoding, mysql, utf-8