Mark Schoonover wrote:
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
Hmmm, didn't know bitch was a valid mysqld error message. :) What was the
exact error message? If you can give it another try...
The reason for doing this is because it's a requirement of running
Slash. Instructions in the Slash INSTALL file say this:
Please refer to MySQL documentation for compilation and/or
installation notes for any questions with this process. Find the
script that runs mysql (probably safe_mysqld) and add these
lines to the beginning of it:
TZ=GMT
export TZ
--
Best Regards,
~DJA.
--
[email protected]
http://www.kernel-panic.org/cgi-bin/mailman/listinfo/kplug-list
