On Wed, Jul 9, 2008 at 4:14 PM, Paul G. Allen <[EMAIL PROTECTED]>
wrote:

> Mark Schoonover wrote:
>
>
>> Well, I'm not experienced in FreeBSD, but the procedure looks the same
>> as on Linux. The setting will be the same zone file name that's in
>> /usr/share/zoneinfo. Test it with
>>
>> mysql> SET GLOBAL time_zone = timezonefile;
>>
>
> Tried that. The file name is GMT and MySQL bitched about it being
> invalid (I tried SET GLOBAL time_zone = GMT; and SET GLOBAL time_zone =
> 'GMT'; and SET GLOBAL time_zone = "GMT";)
>
> I have set the TZ environment variable to GMT though as an alternative.
>
> PGA
> --
> Paul G. Allen, BSIT/SE
> Owner, Sr. Engineer
> Random Logic Consulting Services
> www.randomlogic.com
>


Hmmm, didn't know bitch was a valid mysqld error message. :) What was the
exact error message? If you can give it another try...

-- 
Mark Schoonover, CMDBA
http://www.linkedin.com/in/markschoonover
http://marksitblog.blogspot.com
[EMAIL PROTECTED]

-- 
[email protected]
http://www.kernel-panic.org/cgi-bin/mailman/listinfo/kplug-list

Reply via email to