Jump to content
Larry Ullman's Book Forums

Can Someone Plz Help Me With Loading The Time Zone Table In Chapter 6 Page 190?


Recommended Posts

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:

 

194_8.png

I appreciate in help in advance! 

 

Thanks,

-- Devin

Link to comment
Share on other sites

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!

 

194_8_Mine.png

Link to comment
Share on other sites

 Share

×
×
  • Create New...