roga's blog

Sometimes we don’t have a database management system(DBMS) in our server, so we need to use command line interface to CREATE and IMPORT a database.

Here are some notes:

-- Login to MySQL
debian:# mysql -u root -pPASSWORD

-- Create a utf8 encode database.
CREATE DATABASE DB_NAME DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

-- Use the utf8 connection collation
SET NAMES utf8;

-- Import a utf8 SQL file.
SOURCE filename-utf8.sql

-- or, after create the database, back to system, and use the "mysql" command.
debian:# mysql DB_NAME -u root -pPASSWORD < filename-utf8.sql --default-character-set=utf8

in other way, we also can set my.cnf

[client]
    default-character-set=utf8
[mysqld]
    default-character-set=utf8
    default-collation=utf8_general_ci