On 4/5/2013 1:26 PM, Joe Kosinski wrote:
I cannot find the path where mysql_tzinfo_to_sql is installed.
I have these instructions: This program is installed to the same
.../bin folder as your mysqld binary. Use a "which" command to
clarify where that is on your system.
Then use the path it identifies when executing the utility.
Whenever I type which mysql_tzinfo_to_sql into a prompt nothing
happens and when I try to run the command from the new command prompt
it just says process completed and I get no output.
Do I enter the system command prompt whenever a first open terminal?
Here is the text from my last terminal where I tried to run the which
If you didn't get an error (you actually got a confirmation that it
completed), your timezone tables are most likely populated. Run some
queries against them to check. Do this from a mysql> prompt.
mysql> SELECT * FROM time_zone;
mysql> SELECT * FROM time_zone_name;
Yes, your terminal session is how you get to a system prompt.
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN