Re: Migrating Bugzilla between different time zones - problem

glauber ribeiro <[email protected]>
Newsgroups gmane.comp.mozilla.devel.webtools
Message-ID <[email protected]>
Gutten Tag, Thorsten,

unfortunately, despite my name, i don't speak German (only Portuguese, English, Esperanto or Spanish).

Your message was very useful, thank you. Part of the problem here is my lack of MySQL proficiency. So far, no amount of googling has revealed a way to change the time zone for a database dump. I wish this database were PostgreSQL.

One thing that could be a clue: on both sides, the user preferences for time zone say "(Site Default) America/Chicago'. I would think the new server should say UTC. Where does Bugzilla get that site default time zone from?

When i look into my database, the time stamps seem to be stored in Chicago time, not UTC, but Bugzilla is handling them fine, including timezone conversion if i change my preference.

This is one of those problems that will either be something very simple to fix, or impossible. If i have to live with bad time stamps, c'est la vie. But i want to try a little longer to get it right.

Danken,

glauber
_______________________________________________
support-bugzilla mailing list
[email protected]
https://lists.mozilla.org/listinfo/support-bugzilla
PLEASE put [email protected] in the To: field when you reply.
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.