|
Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com |
Re: 4.0 -> 4.1 lose timestamp
From: Philippe Poelvoorde (philippe
costrading.co.uk)
Date: Tue Aug 16 2005 - 02:14:36 CDT
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Hunter Peress wrote:
> Yes theres all this talk about timestamp returning different results in
> 4.1 vs. 4.0
>
> but i took the MYI and MYD and frm files from a winnt running 4.0.14
> and transferred to a 4.1.11-Debian_4-log
> and all the timestamp fields are NULL
>
> it seems all the other data is fine. Any ideas? i suppose i may just
> have to dump/load instead of copy files.
If you dump them, and reload them, they are usually fine.
If you want to retrieve the correct timestamp (as before), just do
SELECT timestamp + 0 as timestamp FROM ...
(for instance)
--
Philippe Poelvoorde
COS Trading Ltd.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]