α | ȸ | | Ʈ

HOME > >
| ¼ҽ õ ¸ ֽϴ.
 
mysql Ÿ ϱ
ȸ : 24,070  


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 ؾ ϴ 쿡 .


[۸ũ] : https://www.linux.co.kr/home2/board/subbs/board.php?bo_table=lecture&wr_id=1654


  Ʈͷ   ̽   ̷

 
: 缮
e-mail : loclisuperuser.co.kr
Ҽ : ()ڸ