Sunday, January 08, 2006

mysqldump's tz-utc trap

This blog post has moved. Please find it at:

http://www.mpopp.net/2006/01/mysqldumps-tz-utc-trap/.

2 comments:

Markus Popp said...

I don't think that it's a bug, I can dump a table containing date/time information and re-import it and get the same results, at least on the same MySQL 5.0 server from where the dump file results. However, I created yesterday's dump file from a MySQL 4.0 server, so maybe there's some incompatibility. But with disabling tz-utc it was easy to work around this problem.

Unknown said...

Thank you very much for clarifying this. I ran into the problem when restoring parts of a single table due to a user accidentally deleting... in case partial restores are needed, no timezone conversion makes life far more easier.