On Tue, Jun 23, 2009 at 11:18 AM, David Mintz <[email protected]> wrote:
> > > On Tue, Jun 23, 2009 at 10:55 AM, Hans Zaunere <[email protected]> wrote: > >> > You say I should be able to mysqldump a table with TIMESTAMP data from >> > a database residing in NY, move the dump file to a different time zone, >> > load it into the mysql db in that other time zone, and have the >> > TIMESTAMP data still be in US/New York time? I have been banging my >> >> PS, another oddity that I have discovered is that if I prepend "SET TIME_ZONE='US/Eastern'" to my dump.sql and load it (as in "mysql mydatabase <dump.sql "), it just doesn't work. BUT if I start the mysql command line client, tell it "SET TIME_ZONE='US/Eastern'", then "source dump.sql", then it DOES work. WTF? -- David Mintz http://davidmintz.org/ The subtle source is clear and bright The tributary streams flow through the darkness
_______________________________________________ New York PHP Community MySQL SIG http://lists.nyphp.org/mailman/listinfo/mysql NYPHPCon 2006 Presentations Online http://www.nyphpcon.com Show Your Participation in New York PHP http://www.nyphp.org/show_participation.php
