mysql Ÿ ϱ
0.
Ʈ ġ ð
Ǵ 찡 Ѵ .
̷ α 浵 ϳ DB
α ܼȭ ִ .
time_zone κп ˾ƺ .
1. time_zone õ ȯ溯 ̺
time_zone õ ȯ溯
system_time_zone : mysql ŸƮ ȣƮӽ localtime ϴ ̴
ѹ Ǹ ʴ´ .
time_zone : mysql ϴ time_zone ϴ ̴.
⺻ SYSTEM ̸ ̴ system_time_zone Ѵٴ ǹ̴.
time_zone ̺
time_zone : Ÿ ̵ Ǹ leaf θ Ѵ.
time_zone_leap_second :
time_zone_name : Ÿ Ī Ÿӽ ǰ ȴ .
time_zone_transition :
time_zone_transition_type :
2. time_zone Ȯλ
Ÿ
mysql> use mysql
Database changed
mysql> select * from time_zone_name where name='KST';
+------+--------------+
| Name | Time_zone_id |
+------+--------------+
| KST | 1652 |
+------+--------------+
1 row in set (0.00 sec)
Ÿ Ұ
mysql> use mysql
Database changed
mysql> select * from time_zone_name where name='KST';
Empty set (0.00 sec)
Ÿ Ұ time_zone Ÿ̽ ϸ Ÿ .
3. time_zone Ÿ̽
ȣƮ ӽ time_zone Ÿ mysql 밡 Ÿ ϱ ؼ mysql_tzinfo_to_sql ̿Ѵ.
ȣƮ ӽ time_zone Ÿ mysql 밡·
/usr/local/mysql/bin/mysql_tzinfo_to_sql /usr/share/zoneinfo > /root/mysql_time_zone.sql
̱ time_zone Ÿ mysql 밡·
/usr/local/mysql/bin/mysql_tzinfo_to_sql /usr/share/zoneinfo/Asia/Seoul KST > /root/mysql_time_zone_seoul.sql
leaf time_zone mysql 밡· ( ϴ³ ʹ.)
/usr/local/mysql/bin/mysql_tzinfo_to_sql --leaf /usr/share/zoneinfo/Asia/Seoul > /root/mysql_time_zone_seoul.sql
time_zone Ÿ mysql ϵ Ʈ Ѵ .
mysql -u root -p mysql < /root/mysql_time_zone.sql
̱ time_zone Ÿ mysql ϵ Ʈ Ѵ .
mysql -u root -p mysql < /root/mysql_time_zone_seoul.sql
4. Ÿ Ȯ
mysql> show variables;
....
| system_time_zone | EET |
....
| time_zone | SYSTEM |
....
mysql> select now();
+---------------------+
| now() |
+---------------------+
| 2009-02-12 06:39:09 |
+---------------------+
1 row in set (0.00 sec)
mysql> set global time_zone = 'KST';
mysql> quit
ȯ溯 ȁ Ѵ.
]# mysql -u root
mysql> show variables;
....
| system_time_zone | EET |
....
| time_zone | KST |
....
mysql> select now();
+---------------------+
| now() |
+---------------------+
| 2009-02-12 13:39:20 |
+---------------------+
5.
ݱ time_zone 濡 ؼ ˾ƺҴ
̷ ʿϴ ϴ» ֠
time_zone ϴ տ Ͱ α ܼȭ
ð̿ ϴ ȥ ð븦 ؾϴ° (ٱ Ʈ )
ش ð븦 ܼȭñ ִ .
ܼ κ̸ ۾ ִٸ ð Ҷ
mysql ŸƮ Ѿϸ δ Ŀ.
time_zone ؾ ϴ 쿡 .