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
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]