Create database UTF8

mysql> CREATE DATABASE bookshelf DEFAULT CHARACTER SET utf8;

Drop database

mysql> DROP DATABASE ＜データベース名＞;

Import database from file

$ mysql -u username -p database_name < file.sql

Export database to file

$ mysqldump -u username -p database_name > file.sql