title: grails/mysql timezone change
body: <p>Whats the best way to accomplish changing the timezone of an app?  The way I see it the following must occur:</p>
  
  <ol>
  <li>Server TZ is changed by sys admin</li>
  <li>mysql must be restarted.</li>
  <li>every time based column in the database must have all values updated, using convert_tz or equivalent.  So either a mysql script must be written or a grails script that loads every row for each class, updating all the time fields.</li>
  </ol>
  
  <p>Obviously the server should be taken down while this is happening, and backups must be in place incase of an error. </p>
  
  <p>Is there a better/easier way to do this?</p>