ユーザー情報のバックアップ方法は判らず。ユーザの作成と権限の付与は手動で行った。
バックアップ
mysqldump -u root -pROOTPW DATABASE > database.sql
リストア
create database HOGEHOGE;
create user USERNAME;
grant all privileges on DATABASE.* to USERNAME@”localhost” identified by ‘USERPASSWD’ ;
mysql -u root -pROOTPW DATABASE < database.sql
ｍｙｓｑｌの文字コードをUTF-8に設定
# vi /etc/mysql/mysql.cnf
...
[mysqld]
...
default-character-set = utf8
skip-character-set-client-handshake
...
ｍｙｓｑｌの文字コードの確認
mysql -u root -p
mysql>status ;
mysql> status;
————–
mysql Ver 14.12 Distrib 5.0.51a, for debian-linux-gnu (i486) using readline 5.2
Connection id: 8991
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ”
Using delimiter: ;
Server version: 5.0.51a-3ubuntu5.1-log (Ubuntu)
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: utf8
Db characterset: utf8
Client characterset: utf8
Conn. characterset: utf8
UNIX socket: /var/run/mysqld/mysqld.sock
Uptime: 34 days 18 hours 8 min 37 sec
Threads: 1 Questions: 234567 Slow queries: 0 Opens: 1334 Flush tables: 1 Open tables: 64 Queries per second avg: 0.078
————–
mysql>