MySQL command line import of file with UTF-8 encoding
2 July 2009 Linux, 0
Switch language: 
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 
There, I Fixed It Servermanagement with puppet – Part 2
On The Go
- Angeln im Sonnenuntergang an der Naab 26 April 2012
- Doraden angeln im Mittelmeer 31 March 2012
- Bilder aus Mallorca 2012 28 March 2012