2: 2009-04-21 (火) 00:47:54 iseki |
現: 2010-01-09 (土) 14:45:16 admin |
| # /usr/local/mysql5/bin/mysql_install_db --user=mysql --ldata=/var/mysql5 | | # /usr/local/mysql5/bin/mysql_install_db --user=mysql --ldata=/var/mysql5 |
| # cp support-files/my-medium.cnf /var/mysql5/my.cnf | | # cp support-files/my-medium.cnf /var/mysql5/my.cnf |
| + | 注: 通常は /etc/my.cnf にコピー./etc/my.cnf があればそちらが優先される |
| # chown mysql /var/mysql5/my.cnf | | # chown mysql /var/mysql5/my.cnf |
| # /etc/init.d/mysql5 を作る | | # /etc/init.d/mysql5 を作る |
| - 移行先は utf8 | | - 移行先は utf8 |
| | | |
- | **** 移行先を UTF-8 にする [#u5d358e3] | + | **** [[移行先を UTF-8 にする>/MySQL/utf8]] [#u5d358e3] |
- | mysql> show variables like "char%"; | + | |
- | +--------------------------+-----------------------------------------------+ | + | |
- | | Variable_name | Value | | + | |
- | +--------------------------+-----------------------------------------------+ | + | |
- | | character_set_client | latin1 | | + | |
- | | character_set_connection | latin1 | | + | |
- | | character_set_database | latin1 | | + | |
- | | character_set_filesystem | binary | | + | |
- | | character_set_results | latin1 | | + | |
- | | character_set_server | latin1 | | + | |
- | | character_set_system | utf8 | | + | |
- | | character_sets_dir | /usr/local/mysql-5.0.67/share/mysql/charsets/ | | + | |
- | +--------------------------+-----------------------------------------------+ | + | |
- | この場合は latin1 を utf8にする | + | |
- | mysql> set character_set_client=utf8; | + | |
- | mysql> set character_set_connection=utf8; | + | |
- | mysql> set character_set_database=utf8; | + | |
- | mysql> set character_set_results=utf8; | + | |
- | mysql> set character_set_server=utf8; | + | |
- | mysql> show variables like "char%"; | + | |
- | +--------------------------+-----------------------------------------------+ | + | |
- | | Variable_name | Value | | + | |
- | +--------------------------+-----------------------------------------------+ | + | |
- | | character_set_client | utf8 | | + | |
- | | character_set_connection | utf8 | | + | |
- | | character_set_database | utf8 | | + | |
- | | character_set_filesystem | binary | | + | |
- | | character_set_results | utf8 | | + | |
- | | character_set_server | utf8 | | + | |
- | | character_set_system | utf8 | | + | |
- | | character_sets_dir | /usr/local/mysql-5.0.67/share/mysql/charsets/ | | + | |
- | +--------------------------+-----------------------------------------------+ | + | |
| | | |
| **** データベースのストアとリストア [#f598b57c] | | **** データベースのストアとリストア [#f598b57c] |