I am logged onto the system as system administrator and should have privilege to write to the file. I have tried cd .. several times and no matter what I still get permission denied. Please see attached terminal output:
|
Terminal Saved Output 11
Description: Binary data
Thanks,
Joe Begin forwarded message: 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
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.com909-920-9154 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
|