MySQL timestamp?

[Anon]

Hello,
we recently moved to another server. MySQL dump was used to restore MySQL tables on new server. The tables contains a field date (timestamp). Somehow, all dates are changed! Difference beetween each date (old and new one) is exactly 6 hours.
Server is on CEST timezone, if that's relevant.
Does anyone know how to restore old dates? Possible wrong timezone of MySQL server?
Thanks in advance,
Slaven

[Anon]

If it did a literal dump it shouldn't have changed no matter what timezone it's in. Not sure what might have happened, but to fix it, just run this:

update table_name set timestamp_field=sub_date(timestamp_field, interval 6 hour);