title: Mysql: Convert DB from local time to UTC
body: <p>I need to convert an existing (datetime fields) db from local time ut UTC.</p>
  
  <p>The values are stored ad datetimes on a server with time zone CET (+1) (with summertime +2). When selecting data I use <code>UNIX_TIMESTAMP()</code>, which magically compensates for everything, ie, time zone shift and dst (if i've read the docs right).</p>
  
  <p>I'm moving the db to a new server with UTC as system time.</p>
  
  <p>Simply subtracting -1 H won't work, as summer time is +2.</p>
  
  <p>Any ideas for a clever way to do this? (using sql or some script lang)</p>