Re: Migrating Bugzilla between different time zones - problem

Guten Tag glauber ribeiro,
am Mittwoch, 30. September 2020 um 21:45 schrieben Sie:

> 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.

How do you create the dump? The SET-stuff I linked should work.

> 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?

From your server somewhere, so which time zone is your server in? That
is NOT necessarily the same for MySQL, but most likely, it is NOT
necessary the same for your sessions when connecting to MySQL and it
is VERY likely not the time zone used for actual values in the
database of Bugzilla.

> When i look into my database, the time stamps seem to be stored in
> Chicago time, not UTC,

Because of the text I quoted: MySQL knows its UTC, or assumes it or
whatever, and converts the timestamp to the time of your client in the
session you look at the data with. Using the SET-statements you can
change that, SELECT the data again and should see changes. Otherwise
things heavily depend on the tools you are using to look at the
database.

> but Bugzilla is handling them fine, including
> timezone conversion if i change my preference.

Which only makes sense if it properly stores UTC for new records,
doesn't it?

> 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.

https://dba.stackexchange.com/questions/121715/mysqldump-between-servers-with-different-timezones-tz-utc

Mit freundlichen Grüßen,

Thorsten Schöning

-- 
Thorsten Schöning       E-Mail: [email protected]
AM-SoFT IT-Systeme      http://www.AM-SoFT.de/

Telefon...........05151-  9468- 55
Fax...............05151-  9468- 88
Mobil..............0178-8 9468- 04

AM-SoFT GmbH IT-Systeme, Brandenburger Str. 7c, 31789 Hameln
AG Hannover HRB 207 694 - Geschäftsführer: Andreas Muchow

_______________________________________________
support-bugzilla mailing list
[email protected]
https://lists.mozilla.org/listinfo/support-bugzilla
PLEASE put [email protected] in the To: field when you reply.