03-02-2007
$ rpm -qa | grep -i tzdata
tzdata-2006m-3.el4
if an rpm isn't an option...rpm2cpio and cpio are your friend.
review current DST entries:
[root@myBOX share]# /usr/sbin/zdump -v /etc/localtime | grep 2007
/etc/localtime Sun Apr 1 09:59:59 2007 UTC = Sun Apr 1 01:59:59 2007 PST isdst=0 gmtoff=-28800
/etc/localtime Sun Apr 1 10:00:00 2007 UTC = Sun Apr 1 03:00:00 2007 PDT isdst=1 gmtoff=-25200
/etc/localtime Sun Oct 28 08:59:59 2007 UTC = Sun Oct 28 01:59:59 2007 PDT isdst=1 gmtoff=-25200
/etc/localtime Sun Oct 28 09:00:00 2007 UTC = Sun Oct 28 01:00:00 2007 PST isdst=0 gmtoff=-28800
cd temp2
download tzdata rpm
rpm2cpio < tzdata-2007a-1.noarch.rpm > tzdata.cpio
cpio -i -d < tzdata.cpio
[root@myBOX temp2]# ll
total 1379
-rw-rw-r-- 1 jmcontre jmcontre 948008 Feb 6 15:16 tzdata.cpio
-rw-r--r-- 1 jmcontre jmcontre 454553 Feb 6 15:15 tzdata_2006m-3.el4_noarch.rpm
drwx------ 3 jmcontre jmcontre 1024 Feb 6 15:17 usr
[root@myBOX temp2]# chown -R root:root usr
[root@myBOX temp2]# cd usr/share
[root@myBOX share]# ll
total 3
drwx------ 3 root root 1024 Feb 6 15:17 doc
drwxr-xr-x 21 root root 2048 Feb 6 15:17 zoneinfo
[root@myBOX share]# mv /usr/share/doc /usr/share/docOLD
[root@myBOX share]# mv doc /usr/share/
[root@myBOX share]# mv /usr/share/zoneinfo /usr/share/zoneinfoOLD
[root@myBOX share]# mv zoneinfo /usr/share/
review updated DST entries:
[root@myBOX share]# /usr/sbin/zdump -v /etc/localtime | grep 2007
/etc/localtime Sun Mar 11 09:59:59 2007 UTC = Sun Mar 11 01:59:59 2007 PST isdst=0 gmtoff=-28800
/etc/localtime Sun Mar 11 10:00:00 2007 UTC = Sun Mar 11 03:00:00 2007 PDT isdst=1 gmtoff=-25200
/etc/localtime Sun Nov 4 08:59:59 2007 UTC = Sun Nov 4 01:59:59 2007 PDT isdst=1 gmtoff=-25200
/etc/localtime Sun Nov 4 09:00:00 2007 UTC = Sun Nov 4 01:00:00 2007 PST isdst=0 gmtoff=-28800
9 More Discussions You Might Find Interesting
1. Post Here to Contact Site Administrators and Moderators
Hey Neo - or other Unix.com staffers - I've selected my Timezone for the forums - however it's wrong for my Country - as we have Daylight Savings for 6 months of the year - so currently were 1 hour ahead of the time that is provided in the personal options pages. Can we add another for this - no... (5 Replies)
Discussion started by: peter.herlihy
5 Replies
2. UNIX for Dummies Questions & Answers
I was trying to schedule a job to run on the last Sunday of October. To stop a process that I have running before daylight savings automatically falls back at 2AM then restart it after the hour has been regained. I thought I was smart (my mistake) and scheduled the 2 entries in cron. I figured that... (3 Replies)
Discussion started by: cindylouwho
3 Replies
3. Solaris
I have a solaris 8 server - and I need to ensure the daylight savings change properly but I dont think its set up correctly:
/usr/sbin/zdump -v -c 2005 $TZ
GB-EIRE Wed Oct 26 12:20:02 2005 UTC = Wed Oct 26 12:20:02 2005 GB isdst=0
GB-EIRE Fri Dec 13 20:45:52 1901 UTC = Fri Dec 13 20:45:52... (5 Replies)
Discussion started by: frustrated1
5 Replies
4. UNIX for Dummies Questions & Answers
Hey guys,
How do i check and see if my server will automatically adjust itself for daylight savings?
Thanks! (6 Replies)
Discussion started by: kingdbag
6 Replies
5. Solaris
Hello,
I've been looking at coming up with a time change on my Sun workstations since daylight savings time comes early this year. Someone at work told me that a sun patch is available if you have a maintenance contract. It was recommended to just set your systems to GMT time zone. How is this... (5 Replies)
Discussion started by: stocksj
5 Replies
6. Solaris
I am running a SUN E450 on solaris (5.7). I have applied the DST patch and the system time is correct. However when users login the get the time wrong (+4 hours) (I am in EDT Zone). Does anyone know where a system wide variable for this could be set. (Root user gets the right time)
Frank (3 Replies)
Discussion started by: frankkahle
3 Replies
7. AIX
Our aix unix box did not recognize daylight savings time since it was moved up. Could someone please give me the syntax to change the hour? I looked in man and couldn't find anything, or I missed it. I'm in 3rd grade so if you can, please provide specific instructions.
Thanks! (2 Replies)
Discussion started by: vbagwell
2 Replies
8. AIX
Hello everyone
The last sunday I have to check that my servers has change Daylight savings time but only two servers do it and all the rest doesnt.
In smitty where I need to change, for my server take automatic the daylight savings time.
Thanks for your tips
The next its a message for... (0 Replies)
Discussion started by: lo-lp-kl
0 Replies
9. AIX
Hello,
I like to set the CDT timezone, but it shows CST still even after I activated the DayLight Time
cat /etc/environment | grep TZ
TZ=CST6CDT
Now looking at date:
root@test8:/>date
Tue Dec 20 05:34:45 CST 2016
How can I make it from CST to CDT ?
thanks (5 Replies)
Discussion started by: filosophizer
5 Replies
LEARN ABOUT CENTOS
mysql_tzinfo_to_sql
MYSQL_TZINFO_TO_S(1) MySQL Database System MYSQL_TZINFO_TO_S(1)
NAME
mysql_tzinfo_to_sql - load the time zone tables
SYNOPSIS
mysql_tzinfo_to_sql arguments
DESCRIPTION
The mysql_tzinfo_to_sql program loads the time zone tables in the mysql database. It is used on systems that have a zoneinfo database (the
set of files describing time zones). Examples of such systems are Linux, FreeBSD, Solaris, and Mac OS X. One likely location for these
files is the /usr/share/zoneinfo directory (/usr/share/lib/zoneinfo on Solaris). If your system does not have a zoneinfo database, you can
use the downloadable package described in Section 9.6, "MySQL Server Time Zone Support".
mysql_tzinfo_to_sql can be invoked several ways:
shell> mysql_tzinfo_to_sql tz_dir
shell> mysql_tzinfo_to_sql tz_file tz_name
shell> mysql_tzinfo_to_sql --leap tz_file
For the first invocation syntax, pass the zoneinfo directory path name to mysql_tzinfo_to_sql and send the output into the mysql program.
For example:
shell> mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql
mysql_tzinfo_to_sql reads your system's time zone files and generates SQL statements from them. mysql processes those statements to load
the time zone tables.
The second syntax causes mysql_tzinfo_to_sql to load a single time zone file tz_file that corresponds to a time zone name tz_name:
shell> mysql_tzinfo_to_sql tz_file tz_name | mysql -u root mysql
If your time zone needs to account for leap seconds, invoke mysql_tzinfo_to_sql using the third syntax, which initializes the leap second
information. tz_file is the name of your time zone file:
shell> mysql_tzinfo_to_sql --leap tz_file | mysql -u root mysql
After running mysql_tzinfo_to_sql, it is best to restart the server so that it does not continue to use any previously cached time zone
data.
COPYRIGHT
Copyright 2007-2008 MySQL AB, 2008-2010 Sun Microsystems, Inc.
This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as
published by the Free Software Foundation; version 2 of the License.
This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation,
Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA or see http://www.gnu.org/licenses/.
SEE ALSO
For more information, please refer to the MySQL Reference Manual, which may already be installed locally and which is also available online
at http://dev.mysql.com/doc/.
AUTHOR
Sun Microsystems, Inc. (http://www.mysql.com/).
MySQL 5.1 04/06/2010 MYSQL_TZINFO_TO_S(1)