import utf8 MySQL encoding by default to my hosting

[valila]

How do I set MySQL to import utf8 encoding by default? I made test on many scripts, but alas there cannot find a simple command which may do it to my hosting MySQL database.

[misterhard]

You must configure what encoding to use your connection.

#mysql
SET NAMES UTF8;
source path_to_sql_file.sql

This will fulfil query in the SQL file, and if has inserting will be inserted with the upper encoding. If you are using phpMyAdmin - at the top has drop-down menu for selecting the encoding.

[KODY]

Open the file called my.cnf and within the section [client] write a line:
Sample code:

default-character-set=utf8

and within the section [mysqld] write these lines:
Sample code:

default-character-set=utf8
init-connect="SET NAMES utf8"

Restart MySQL and everything should be fine. Previously made backup of all databases.

[carlobee]

this is a very useful information! thanks for this one.