short.fuse.5254 Posted August 3, 2014 Share Posted August 3, 2014 Hi everyone, I just finished reading Chapter 6, & I'm stuck on Page 190 on the part Using Time Zones in MySQL... I'm not sure where to start. I checked out this page http://dev.mysql.com/doc/refman/5.0/en/time-zone-support.html, but I can't make too much sense out of it! I installed Xampp in C:. I found this folder with the Time Zone tables, but I have no idea what to do even after reading the time zone support page on the MySQL website...: C:\xampp\mysql\data\mysql It has all 15 of the time zone files, but I don't know what to do. I'm using Version 3.2.1 of Xampp, Version 5.5.11 of PHP, & Version 5.0.11 -dev of MySQL... I tried example 8 on Page 194 of the book, & this is how it turned out: I appreciate in help in advance! Thanks, -- Devin Link to comment Share on other sites More sharing options...
short.fuse.5254 Posted August 3, 2014 Author Share Posted August 3, 2014 I think I've got this all sorted out now, so I figured I should post how I got everything done to help anyone else who has the same problem. First, I clicked the xampp control panel, & clicked the stop buttons next to Apache & MySQL. Next, I went to: http://downloads.mysql.com/general/timezone_2011n_posix.zip , & I downloaded the zip folder (It has all of the 15 tables files in it.). I extracted the folder, selected all of the 15 files in it, copied them, & pasted them in the folder C:\xampp\mysql\data\mysql. A window will come up asking you if you want to replace the files or skip them: Replace them... Then I restarted Apache & MySQL & got the example in Chapter 6 on page 194 to work! Link to comment Share on other sites More sharing options...
JohnD Posted August 4, 2014 Share Posted August 4, 2014 Nice work! Thanks for the detailed post on how to configure this. You have saved me a lot of trial and error. Link to comment Share on other sites More sharing options...
short.fuse.5254 Posted August 4, 2014 Author Share Posted August 4, 2014 Nice work! Thanks for the detailed post on how to configure this. You have saved me a lot of trial and error. Your welcome @JohnD... It took me a while to figure out how to do this myself. I think I was on Google for an hour or two trying to find an article on how to do this. Link to comment Share on other sites More sharing options...
Larry Posted August 4, 2014 Share Posted August 4, 2014 Thanks for sharing all that and kudos for figuring it out. Link to comment Share on other sites More sharing options...
short.fuse.5254 Posted August 5, 2014 Author Share Posted August 5, 2014 Thanks for sharing all that and kudos for figuring it out. You're welcome Mr. Larry. Link to comment Share on other sites More sharing options...
Recommended Posts