Re: timestamps

[Jeff Mathis]

when did 4.1.4 come out? as of last week, we couldn't see it on the 
website. at any rate, it was only a minor inconvenience. we've moved on, 
and everything appears stable right now.

thanks for your repsonse

jeff
Heikki Tuuri wrote:
> Jeff,
> 
> please look at the changelog of InnoDB-4.1.4 in the MySQL manual.
> 
> An upgrade 4.0 --> 4.1.4 or later does NOT need any TIMESTAMP conversion.
> 
> It is a bug in 4.1.0 to 4.1.3.
> 
> Regards,
> 
> Heikki
> 
> ----- Alkuperäinen viesti ----- 
> Lähettäjä: "Jeff Mathis" <jmathis@stripped>
> Vastaanottaja: "Mark Matthews" <mark@stripped>
> Kopio: <java@stripped>; "Heikki Tuuri" <Heikki.Tuuri@stripped>
> Lähetetty: Wednesday, August 04, 2004 10:31 PM
> Aihe: Re: timestamps
> 
> 
> 
>>yes, they are innodb tables. i populated the new time_zone tables using
>>the system time zone files as per the manual recommendations, but, alas,
>>no change.
>>
>>are you saying that its all messed up? dumping and reloading really
>>isn't the greatest option  :(
>>
>>jeff
>>Mark Matthews wrote:
>>
>>>-----BEGIN PGP SIGNED MESSAGE-----
>>>Hash: SHA1
>>>
>>>Jeff Mathis wrote:
>>>| hello,
>>>|
>>>| sorry if this is a know issue. we just upgraded our server from 4.0.4
> 
> to
> 
>>>| 4.1.3, and are now using the 3.1.3 CJ release.
>>>|
>>>| i noticed that after the upgrade, all our timestamp columns are wrong!
>>>|
>>>| | 2036-07-09 05:45:55 |
>>>| | 2036-07-15 05:42:42 |
>>>| | 2036-07-15 05:42:45 |
>>>| | 2036-07-15 05:42:45 |
>>>| | 2036-07-16 05:42:35 |
>>>|
>>>| everything is wrong; the year, month and day. what happened? anyone
> 
> else
> 
>>>| seen this?
>>>|
>>>| jeff
>>>|
>>>
>>>Jeff...Are these InnoDB tables? (If so, unfortunately it looks like
>>>you'll have to dump and re-load, from what I hear).
>>>
>>>    -Mark
>>>
>>>- --
>>>Mr. Mark Matthews
>>>MySQL AB, Software Development Manager, J2EE and Windows Platforms
>>>Office: [phone]
>>>www.mysql.com
>>>
>>>MySQL Guide to Lower TCO
>>>http://www.mysql.com/it-resources/white-papers/tco.php
>>>-----BEGIN PGP SIGNATURE-----
>>>Version: GnuPG v1.2.3 (MingW32)
>>>Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
>>>
>>>iD8DBQFBETGItvXNTca6JD8RArFgAKCBlujs3RqozStFLCn2Fkyf7AuzFwCgkHA6
>>>6bshoNnrkKIjVOgIrjn8fHw=
>>>=5HFm
>>>-----END PGP SIGNATURE-----
>>>
>>
>>
>>-- 
>>Jeff Mathis, Ph.D. 505-955-1434
>>Prediction Company jmathis@stripped
>>525 Camino de los Marquez, Ste 6 http://www.predict.com
>>Santa Fe, NM 87505
>>
> 
> 
> 


-- 
Jeff Mathis, Ph.D.			505-955-1434
Prediction Company			jmathis@stripped
525 Camino de los Marquez, Ste 6	http://www.predict.com
Santa Fe, NM 87505