Am 07.04.2013 03:26, schrieb Joe Kosinski:
> I was finally able to load the time zone tables using the following:
> sh-3.2# /usr/local/mysql-advanced-5.6.10-osx10.7-x86/bin/mysql_tzinfo_to_sql
> /usr/share/zoneinfo | /usr/local/mysql-advanced-5.6.10-osx10.7-x86/bin/mysql
> -
I was finally able to load the time zone tables using the following:
sh-3.2#
/usr/local/mysql-advanced-5.6.10-osx10.7-x86/bin/mysql_tzinfo_to_sql
/usr/share/zoneinfo | /usr/local/mysql-advanced-5.6.10-osx10.7-x86/bin/mysql -u
root mysql
My version of Mac OSX 10.8.3 did not have root
I also tried mysql_tzinfo_to_sql /usr/share/zoneinfo > sqlLines with the following Terminal output:
Terminal Saved Output 10
Description: Binary data
-bash: sqlLines: Permission deniedJoeBegin forwarded message:From: Joe Kosinski <joj...@gmail.com>Subject: Fwd: mysql_tzinfo_t
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
Am 06.04.2013 12:49, schrieb Reindl Harald:
> Am 06.04.2013 03:51, schrieb Joe Kosinski:
>> I am logged onto the system as system administrator and should have
>> privilege to write to the file
no you are on MACOSX
on this crippled OS a administrator is not the same as root
>> I have tried cd
Am 06.04.2013 17:46, schrieb Joseph Kosinski:
> Thanks for the input. I have noticed when I wanted to remove MySql Server
> from my system
> there were a lot of steps I had to go through and one was to modify the
> config file which
> was locked
not really - the problem is you are lacking an
indl Harald
> Subject: Re: mysql_tzinfo_to_sql
> Date: April 6, 2013 6:57:42 AM EDT
> To: mysql@lists.mysql.com
>
>
>
> Am 06.04.2013 12:49, schrieb Reindl Harald:
>> Am 06.04.2013 03:51, schrieb Joe Kosinski:
>>> I am logged onto the system as system administrator
> Joseph-Kosinskis-MacBook:bin josephkosinski$ mysql_tzinfo_to_sql
> /usr/share/zoneinfo > sqlLines
> -bash: sqlLines: Permission denied
if you need help post your damned commands UNSTRIPPED and mask only passwords
and inline is preferred instead attachments which are wasting oth
forwarded message:From: "Wm Mussatto" <mussa...@csz.com>Subject: Re: Fwd: mysql_tzinfo_to_sqlDate: April 5, 2013 5:09:15 PM EDTTo: mysql@lists.mysql.comOn Fri, April 5, 2013 13:19, Joe Kosinski wrote:I also tried mysql_tzinfo_to_sql /usr/share/zoneinfo > sqlLines with thefollow
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
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_tz
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.
which mysql_tzinfo_to_sql
Then use t
d to locate the path to the mysql_tzinfo_to_sql previously nothingworked.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 sessionuse mysql;-- Shawn GreenMySQL Principal Technica
date
(like from an "apt-get update") and re-run "mysql_tzinfo_to_sql tz_file".
You'll have to store the "Name" column instead otherwise you loose data
integrity.
That script wipes the tables and re-creates them! rather than doing an
UPDATE to existing r
i used mysql_tzinfo_to_sql utility to create timezone_* database after
upgrading zoneinfo in my host.
after that i am seeing this mismatch.
'America/Sao_Paulo' (http://www.timeanddate.com/worldclock/city.html?n=233) and
'America/Buenos_Aires' (http://www.timeanddate.com/
On Mon, 10 Mar 2008, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: wrote:
The command worked with this syntax:
root> mysql_tzinfo_to_sql /usr/share/zoneinfo/America/ | mysql -D mysql -u xxx
-p xxx
It's easy to know that the command ran without error, but I don't know
how
On Mon, Mar 10, 2008 at 11:36 AM, Tim McDaniel <[EMAIL PROTECTED]> wrote:
> On Mon, 10 Mar 2008, Daniel Brown <[EMAIL PROTECTED]> wrote:
> >mysql -D mysql -u xxx -p < mysql_tzinfo_to_sql
> /usr/share/zoneinfo/America/
> >
> >The -D flag selects t
> Its example line is
> mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql
> There's a trailing "mysql", which specifies the "mysql" database.
> It also specifies all zoneinfo, not "America/".
Thanks, Tim. I totally missed the trailing mysql. Duh!
--David.
> On Mon, Mar 10, 2008 at 11:07 AM, <[EMAIL PROTECTED]> wrote:
>> I'm getting an error trying to run this command:
>>
>> root> mysql_tzinfo_to_sql /usr/share/zoneinfo/America/ | mysql -u xxx
-p
>> xxx
>>
>> ERROR 1046 (3D000) at line 1:
On Mon, 10 Mar 2008, Daniel Brown <[EMAIL PROTECTED]> wrote:
mysql -D mysql -u xxx -p < mysql_tzinfo_to_sql /usr/share/zoneinfo/America/
The -D flag selects the database `mysql`, which is where the time
zone information belongs. The < redirect reads from the "file"
On Mon, 10 Mar 2008, [EMAIL PROTECTED] wrote:
I'm getting an error trying to run this command:
root> mysql_tzinfo_to_sql /usr/share/zoneinfo/America/ | mysql -u xxx -p
xxx
ERROR 1046 (3D000) at line 1: No database selected
The MySQL 5.0 manual explains mysql_tzinfo_to_sql
On Mon, Mar 10, 2008 at 11:07 AM, <[EMAIL PROTECTED]> wrote:
> I'm getting an error trying to run this command:
>
> root> mysql_tzinfo_to_sql /usr/share/zoneinfo/America/ | mysql -u xxx -p
> xxx
>
> ERROR 1046 (3D000) at line 1: No database select
I'm getting an error trying to run this command:
root> mysql_tzinfo_to_sql /usr/share/zoneinfo/America/ | mysql -u xxx -p
xxx
ERROR 1046 (3D000) at line 1: No database selected
Funny thing is I know I've run this on 2 other servers with identical
software without issue, howev
23 matches
Mail list logo
