1. Backing Up the database
[Email protected] ~]# mysqldump-h 192.168.0.8-uroot-p ' 123456 ' user >user.sql
2. View MySQL database character set settings
Mysql> Show variables like ' character_set_% ';
+--------------------------+----------------------------+
| variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | Latin1 |
| character_set_connection | Latin1 |
| Character_set_database | UTF8 |
| Character_set_filesystem | binary |
| Character_set_results | Latin1 |
| Character_set_server | UTF8 |
| Character_set_system | UTF8 |
| Character_sets_dir | /usr/share/mysql/charsets/|
+--------------------------+----------------------------+
8 rows in Set (0.00 sec)
3. Changing the character set of a database
mysql> ALTER DATABASE opensips default character set ' UTF8 ';
4. Specifying a character set when creating a database
mysql> Create databse opensips character set UTF8 collate utf8_general_ci;
5. Specify the default character set for the created database in MySQL configuration file/etc/my.cnf
[Mysqld]
Default-character-set=utf8
Datadir=/var/lib/mysql
Socket=/var/lib/mysql/mysql.sock
User=mysql
# Disabling Symbolic-links is recommended to prevent assorted security risks
Symbolic-links=0
[Mysqld_safe]
Log-error=/var/log/mysqld.log
Pid-file=/var/run/mysqld/mysqld.pid
[Client]
Default-character-set=utf8
This article is from the "Cloud Life" blog, make sure to keep this source http://ovcer.blog.51cto.com/1145188/1430465