Thanks,

Joe

Begin forwarded message:

From: "Wm Mussatto" <mussatto@csz.com>
Subject: Re: Fwd: mysql_tzinfo_to_sql
Date: April 5, 2013 5:09:15 PM EDT
To: mysql@lists.mysql.com

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

Joe
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 <jojako@gmail.com>
Subject: Fwd: mysql_tzinfo_to_sql
Date: April 5, 2013 3:25:59 PM EDT
To: "mysql@lists.mysql.com" <mysql@lists.mysql.com>

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
populated.

2. Then I tried to find the path of mysql_tzinfo_to_sql by running the
command
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
tables?

Joe



Joe

Begin forwarded message:

From: shawn green <shawn.l.green@oracle.com>
Subject: Re: Fwd: mysql_tzinfo_to_sql
Date: April 5, 2013 1:58:01 PM EDT
To: Joe Kosinski <jojako@gmail.com>

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
nothing
worked.


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
http://www.csz.com
909-920-9154


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql