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 <joj...@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.gr...@oracle.com> >>>> Subject: Re: Fwd: mysql_tzinfo_to_sql >>>> Date: April 5, 2013 1:58:01 PM EDT >>>> To: Joe Kosinski <joj...@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
