Gentoo Archives: gentoo-server

From: Christian Bricart <christian@×××××××.de>
To: gentoo-server@l.g.o
Subject: Re: [gentoo-server] [friendly reminder] sys-libs/timezone-data and MySQL
Date: Fri, 01 Dec 2006 12:57:12
Message-Id: 45822.80.87.162.74.1164977585.squirrel@aachalon.de
In Reply to: [gentoo-server] [friendly reminder] sys-libs/timezone-data and MySQL by Francesco Riosa
1 > after an upgrade of sys-libs/timezone-data is good advice to update the
2 > mysql timezones tables too:
3 >
4 > # mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -p mysql
5 >
6 > for details refer to
7 > http://dev.mysql.com/doc/refman/5.0/en/time-zone-support.html
8
9 also - contrary to most Distro installation docs (which includes Gentoo
10 ;-) ):
11
12 In those docs, /etc/localtime ought to be copied from
13 /usr/share/timezone/XX/YY
14 Personally, I rather set a symlink than copy the file...
15 Has the following advantages:
16 - It's clearly visible what's the configured timezone (by simply reading
17 the link text ;-) )
18 - updates to timezone-data update system's timezone automagically
19
20 Drawbacks:
21 according to FHS /usr may be a remote filesystem, but /etc/localtime has
22 to exist during boot.
23
24 Christian
25
26 --
27 gentoo-server@g.o mailing list

Replies

Subject Author
[gentoo-server] remote /usr Alex Efros <powerman@××××××××××××××××××.com>