Jump to content
Larry Ullman's Book Forums
Sign in to follow this  
short.fuse.5254

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

Share this post


Link to post
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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

×
×
  • Create New...