Begin forwarded message:

From: "Wm Mussatto" <>
Subject: Re: Fwd: mysql_tzinfo_to_sql
Date: April 5, 2013 5:09:15 PM EDT

On Fri, April 5, 2013 13:19, Joe Kosinski wrote:
I also tried mysql_tzinfo_to_sql /usr/share/zoneinfo > sqlLines with the
following Terminal output:

-bash: sqlLines: Permission denied

Well at lease we are on familiar territory now.  Whatever directory you
are in requires that the user you are have permission to write to it.  Try
doing a "cd" first. That should get you back to the user's home directory
where I would hope that user could create files.
Begin forwarded message:

From: Joe Kosinski <>
Subject: Fwd: mysql_tzinfo_to_sql
Date: April 5, 2013 3:25:59 PM EDT
To: "" <>

1.I was able to use the use mysql; to change to the mysql database and
then I ran the queries which showed that the time zone database is not

2. Then I tried to find the path of mysql_tzinfo_to_sql by running the
which mysql_tzinfo_to_sql with the following results:
Last login: Fri Apr 5 14:50:02 on ttys000 which mysql_tzinfo_to_sql ;
exit; Joseph-Kosinskis-MacBook:~ josephkosinski$ which
mysql_tzinfo_to_sql ; exit; logout [Process completed]

However,  there was no output showing the path.  I ran the which command
from the command drop down menu of the Shell menu.

Are there any other suggestions on what I should do to populated the



Begin forwarded message:

From: shawn green <>
Subject: Re: Fwd: mysql_tzinfo_to_sql
Date: April 5, 2013 1:58:01 PM EDT
To: Joe Kosinski <>

Hi Joe,

On 4/5/2013 1:58 PM, Joe Kosinski wrote:
The commands didn't work and the time zone tables are not loaded.
Whenever I ran the queries mysql> SELECT * FROM time_zone;
mysql> SELECT * FROM time_zone_name;
I got an error message stating no database was selected.  I think
when I
tried to locate the path to the mysql_tzinfo_to_sql previously

All tables are organized into databases. The timezone tables are in
the `mysql` database. To change your active database, use the 'use'
command in your session

use mysql;

Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN

William R. Mussatto
Systems Engineer

MySQL General Mailing List
For list archives:
To unsubscribe: