On 12-Apr-2004 Riaan Oberholzer wrote: > I'm, using mysqldump to dump a complete database on a > server in The Netherlands and want to load the > generated SQL onto a server in the USA to make an > exact copy of the database. > > However, I have Timestamp(14) fields that are dumped > as e.g. "20041010150000" local time and is read as > local time too on the USA server. Ie, the time is then > off by 10 odd hours. > > How can I dump the database to generate SQL timestamps > in GMT and also make it being read as GMT on the other > side? >
A. run both servers on the same time-zone. B. load the data and run the query: UPDATE tbl SET ts= DATE_SUB(ts, INTERVAL 10 HOUR) WHERE ... Regards, -- Don Read [EMAIL PROTECTED] -- It's always darkest before the dawn. So if you are going to steal the neighbor's newspaper, that's the time to do it. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
