And the answer is.... (drum roll, please)........
whatever else you do, pipe the mysqldump output to
sed "s/TIME_ZONE='+00:00'/TIME_ZONE='-03:00'/"
Many thanks,
David
On Tue, Jun 23, 2009 at 11:23 AM, David Mintz <[email protected]> wrote:
>
>
> 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
>
--
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
