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 -- KPLUG-List@kernel-panic.org http://www.kernel-panic.org/cgi-bin/mailman/listinfo/kplug-list
