I'm Marnanel, and this is my blog. Well, sort of. It isn't timely like a blog, and I don't expect you to subscribe to the feed (though I won't complain if you do). Rather, treat it as a quick trot around my mind, a chat over a pint in the pub, assuming you'd be caught dead talking about software in the pub. You should start here.

Thursday, June 07, 2007

Unknown or incorrect time zone: 'UTC'

If mysql says: Unknown or incorrect time zone: 'UTC' then it doesn't know the timezone database. You can test this by typing mysql> SET time_zone='UTC'; which will succeed only if it knows the timezone UTC (which it should).

The command to fix it is
$ mysql_tzinfo_to_sql /usr/share/zoneinfo/|mysql -u root mysql -p

(leave off the -p if your root account doesn't have a password, in case you are insane)