Re: [Q] moving database to server in new timezone

2004-04-12 Thread Don Read
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. "200

[Q] moving database to server in new timezone

2004-04-12 Thread Riaan Oberholzer
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. "2004101015" local time and is read as local time too