> 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
I actually had meant just to store the text file itself (as a text file) to a remote location, then you can restore it back to the main server if needed. Since it won't be loaded into a database in a different timezone, there wouldn't be any issues. > head for hours now, trying adding SET TIME_ZONE='US/Easterm' and > various tricks, nothing works. Here's an example, maybe someone can see > where I am going wrong: What if you try something like this: SET TIME_ZONE='-05:00'; H _______________________________________________ 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
