Starting in spring 2007, most of the United States and Canada will observe Daylight Saving Time during the period between the second Sunday in March and the first Sunday in November, thanks to acts of the federal legislature.
A simple software update from the central repositories using your distribution's or operating system's software management tools should do the trick if that is an option.
Such tools include, for instance: Additionally, Free BSD, Slackware Linux, and other free UNIX-like operating systems have their own tools for the same tasks.
I also tried just replacing my zoneinfo folder with this new data, and got the error that my timezone database was corrupt. :) After doing that, and restarting mysql, restarting nginx, I'm still getting mysql errors - mysql doesn't know the time zones I'm using (things like, US/Hawaii, US/Alaska, US/Pacific).
Am I missing something obvious, or am I missing instructions somewhere on how to do this? (I'm trying to do this because mysql is giving me errors like this: 'error: SET time_zone = 'US/Pacific' Unknown or incorrect time zone: 'US/Pacific'). These are all listed in the list of tz database time zones here on Wikipedia: en.wikipedia.org/wiki/List_of_tz_database_time_zones - what could be wrong?
The methods will vary from operating system to operating system, but they should all provide tools for installing the packages without direct access to the archives.
See your operating system documentation for details.
These cases include examples where there is no Internet connectivity or where such connectivity is limited so that regular software updates are not feasible, such as having only dial-up Internet access.
For these users, the problem becomes slightly less straightforward.
Below is a list of links to the relevant software updates for common operating systems: In cases where the port or package you need to update your time zone configuration is not available, you should be able to change the configuration yourself almost as easily.